creating a query or report from multiple tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

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).
 
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).
Click to expand...

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]
 
Back
Top