creating a query or report from multiple tables

[Guest]

I have two exact tables (one for each user to enter their pending work info
into). I have created queries and reports for each table. However, I want
to have one report or query (whichever is easier) to pull the info (that
meets certain requirements) from both their tables. Does this make sense?
If not I can explain further. Please help as I am newbie but have learned a
lot through the discussion forum. Thanks in advance for your help.
For example I have: Employee 1 Table of work
Employee 2 Table of work
all the fields are the same in both tables....I want to pull data from both
tables into one report or query (if certain data requirements are met).

 

[Rick B]

Answered in one of your other posts. Please do not post duplicate messages.

 

[John Vinson]

I have two exact tables (one for each user to enter their pending work info
into). I have created queries and reports for each table. However, I want
to have one report or query (whichever is easier) to pull the info (that
meets certain requirements) from both their tables. Does this make sense?
If not I can explain further. Please help as I am newbie but have learned a
lot through the discussion forum. Thanks in advance for your help.
For example I have: Employee 1 Table of work
Employee 2 Table of work
all the fields are the same in both tables....I want to pull data from both
tables into one report or query (if certain data requirements are met).

A UNION query will do this. See the online help for UNION.

As a rule it's best *not* to have separate tables with the same
structure in your database, though! Access is multiuser; there is no
obvious reason why the two employees shouldn't be entering data into
the same table. Do you have some reason not to do so?

John W. Vinson[MVP]