queries which pull data in multiple "rows" in one table and compar

  • Thread starter Thread starter Da Chosen One
  • Start date Start date
D

Da Chosen One

I have a project to complete where the end user wants me to write several
queries which pull data in multiple "rows" in one table and compare them to
data in another using access. He also needs a report written based on the
findings of which data meets certain criteria within those queries. I think
the report part will be pretty easy, but can someone give me some suggestions
on what would be the best way to create the queries in access?

Thanks
Da Chosen One
 
On Sun, 10 Jan 2010 19:22:01 -0800, Da Chosen One <Da Chosen
(e-mail address removed)> wrote:

Your question is too vague to answer. Can you reduce the problem to
the essentials, describe the tables involved, and what you want the
output to be?

-Tom.
Microsoft Access MVP
 
On Sun, 10 Jan 2010 19:22:01 -0800, Da Chosen One <Da Chosen
I have a project to complete where the end user wants me to write several
queries which pull data in multiple "rows" in one table and compare them to
data in another using access. He also needs a report written based on the
findings of which data meets certain criteria within those queries. I think
the report part will be pretty easy, but can someone give me some suggestions
on what would be the best way to create the queries in access?

Thanks
Da Chosen One
Click to expand...

By using the "New Query" button on the database window, and adding the
appropriate tables, fields, criteria, and join lines. You would then base the
Report on the query.

For help doing so please post enough information that someone who cannot see
the database might have a chance to help.
 
Back
Top