Need Records from 2 Tables

[PB]

I have an Employee table in Access that is updated weekly from a Payroll
system. If someone is terminated, they will no longer be in this table. It
was suggested I create a "History" table to keep from losing these terminated
records. BUT, this would mean when I query to find an associate, I would
need to look at all the records from the Employee Table, and just the
unmatched records in the "History" table. With what I know of joins, there
isn't a way to do this. So what do I do?

Any help would be greatly appreciated!!

 

[Steve Schapel]

PB,

If you move the terminated emplyees to a History table, then you will
still be able to use that data in queries of the type you have indicated.

However, it is probably a lot easier to simply have a field in the
Employee table to show whether the person is terminated. For example a
DateFinished field (if this is Null you know they are current), or a
Yes/No data type field Terminated. And then you can use a criteria on
this field to control which recordss are being used at any given time.