Results 1 to 3 of 3
  1. #1
    BuzzTheMan2 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    2

    Single Table looking for missing entry

    What I have is 1 table (tblTracking) with Login & Logout records with also job records with date stamps in this 1 table (I do have an employee table) and each employee has a employee ID number.


    I would like a query or form with script that shows who didn’t logout for today (in the field OperationCode). That is if there is a Login record (in field OperationCode) for today and no Logout record, then give me a report so I can send Emails to Team Leaders of the employees that did not logout.

    It seems easy but I can show if there is both records etc but not if 1 Logout record is missing.
    I sometime make thing harder than they should be but I can’t figure this query out even using inner and outer SQL queries.
    Any help would greatly be apprecated.

    Buzz

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Did you try the FindUnmatched query wizard?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    BuzzTheMan2 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jan 2012
    Posts
    2
    Yes I did, I did figure it out, created 2 queries, Login & Logout, then created third query, counted the login & Logout in each query and linked back to Employee ID's. Working good.
    Thanks for your help.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Searching for a single word in all table
    By rielcas in forum Access
    Replies: 1
    Last Post: 06-19-2013, 06:28 AM
  2. many-to-many relationship to a single table
    By roleic in forum Database Design
    Replies: 2
    Last Post: 08-01-2012, 03:41 PM
  3. Missing Records in a Table (Access 2003)
    By Shayne in forum Access
    Replies: 7
    Last Post: 10-13-2011, 07:13 AM
  4. Linked table from outlook missing columns
    By nehamd4 in forum Access
    Replies: 0
    Last Post: 07-21-2010, 12:58 PM
  5. Replies: 0
    Last Post: 08-01-2009, 12:43 PM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums