G
Gahbeck
I am trying to create a query that will check the current clocked in or out
status of employees and return a variable of out or in. The employees may
punch in and out 2 or 3 times per day. I have a table with the fields
Time_ID, Employee_Number, Department, Timestamp, In_Out, and Comments. The
Timestamp field is a set to now() and the employee selects In or Out
depending on what he or she is doing. I am trying to figure out how I can
look at the timestamps in the computer and figure out what his or her last
timestamp was... in or out. Would appreciate any suggestions.
Gary Hollenbeck
Production Manager
Western Cabinet Doors, Inc.
status of employees and return a variable of out or in. The employees may
punch in and out 2 or 3 times per day. I have a table with the fields
Time_ID, Employee_Number, Department, Timestamp, In_Out, and Comments. The
Timestamp field is a set to now() and the employee selects In or Out
depending on what he or she is doing. I am trying to figure out how I can
look at the timestamps in the computer and figure out what his or her last
timestamp was... in or out. Would appreciate any suggestions.
Gary Hollenbeck
Production Manager
Western Cabinet Doors, Inc.