Single Table looking for missing entry
Windows 7 32bit 
Access 2007
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
Reply With Quote
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.
