Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Aug 2001
    Location
    Boston, Massachusetts, USA
    Posts
    167
    Thanks
    1
    Thanked 0 Times in 0 Posts

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

    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
    thanks
    christine

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

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

    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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •