I have a table that contains the following information:
BadgeID - employee's ID #
Punch - Date and Time Stamp
Sequence - 1 (for in) and 2 (for out punches)
There are usually 2 - 3 sets of sequences per day for each employee. I am trying to create a query that calculates the employee's time for that day.
Ex:
Punch: 9/26/2005 8:00 AM Seq: 1
9/26/2005 12:00 PM Seq: 2
9/26/2005 12:30 PM Seq: 1
9/26/2005 4:30 PM Seq: 2
I would expect this to come up with 8 hrs.
I am stuck on how I can calculate this with a query. Any thoughts?
Thank you for your help.
Nickela
BadgeID - employee's ID #
Punch - Date and Time Stamp
Sequence - 1 (for in) and 2 (for out punches)
There are usually 2 - 3 sets of sequences per day for each employee. I am trying to create a query that calculates the employee's time for that day.
Ex:
Punch: 9/26/2005 8:00 AM Seq: 1
9/26/2005 12:00 PM Seq: 2
9/26/2005 12:30 PM Seq: 1
9/26/2005 4:30 PM Seq: 2
I would expect this to come up with 8 hrs.
I am stuck on how I can calculate this with a query. Any thoughts?
Thank you for your help.
Nickela