Records that 2 tables do NOT have in common (Access 97)

Topic

New Reply

I have a table that contains employee ID information. I have a second table that the employees use to log hours worked. I am trying to create a query that would list all employees that have not logged hours for a particular day. (I’ve already setup a [Enter Work Date] parameter that would refresh on open. How can I do this?

thanks in advance
christine

Reply | Quote

Replies

First create a query (if you haven’t already done so) that selects records in the second table for a particular day. Then use the Find Unmatched Wizard for this. Click New in the Queries tab, and select the Find Unmatched wizard. Select the Employees table in the first step, and the query in the second step.

Reply | Quote