Hi EHC,
You can use an unmatched query to find records in the daily source that are
not in your main table. Assuming you have either linked or imported the daily
source, there is a query wizard that will help guide you through the process.
It would be best to use a unique identifier field such as EmployeeNumber, if
possible, instead of trying to match based on First and Last names. However,
if there is no unique identifier field present, then you'll have to use the
names. The wizard allows one to pick one field, which should work out okay as
long as the first and last names are together, in one field. If, however, the
first and last names are in different fields, then you can always edit the
query after the wizard creates it, by adding another outer join (join line
with an arrow pointing to one field), along with adding the null criteria for
your second field that the wizard creates for one field.
To invoke this wizard within Access 2000, 2002 or 2003, click on the Queries
tab. Then click on the New button, and select the last entry "Find Unmatched
Query Wizard". Follow the prompts carefully, selecting the linked or imported
table that represents your daily list first.
Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________
