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