Query

F

Frustrated

I have two tables. One contains contigent employees the other full-time
employees. I would like to create a query that combines these two tables, so
the contigent and full-time employees are all on one report. How can I
accomplish this?

Thanks for your help
 
J

Jeff Boyce

Is there a business reason these two tables are kept separated? For
instance, the data elements you keep about "contingent" employees differs
from the data you keep about "full-time" employees?

If you have two identical tables (same structure), one for each "type" of
employee, your data is structured like a spreadsheet, not a well-normalized
relational database.

If you are keeping (essentially) the same data about both types, use a
single table, and add a single field that indicates if the employee is
"contingent" (a Yes/No field), or possibly, the date the employee became
full-time (Date/Time field).

Or is there more to know/understand about your situation...?

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/
 
Top