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

[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

 

[Tom van Stiphout]

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

 

[John W. Vinson]

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

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.