queryfrom two tables

[Guest]

I have two tables with basically the same fields: name, account, total
salary..., but one is for faculty and the other for staff. I am trying to do
a query to do a report, in which I want to view people from the two tables
under a certain account number. Can this be done?

When I created the query it seems as if I can only point to one table under
one field.

 

[Rick B]

Yes, create a UNION query. The help files will tell you how.

You may also want to think about if your table structure is correct. Could
you combine the tables into one employee table and add a "type" field where
you select faculty or staff? this scenario may not make sense if your table
structures are different, but something to consider.

Creating and saving that UNION query will let you pull data from both tables
when you need it.

 

[Guest]

Thank you, that was very helpful.

Yes, create a UNION query. The help files will tell you how.

You may also want to think about if your table structure is correct. Could
you combine the tables into one employee table and add a "type" field where
you select faculty or staff? this scenario may not make sense if your table
structures are different, but something to consider.

Creating and saving that UNION query will let you pull data from both tables
when you need it.