Unanswered: HELP (first in / last out each day for each employee)
I have a database that tracks when each employee swipes in/out each day. I am trying to produce a report that will show the first time each employee swipes in each day and the last time an employee swipes out each day. I have a field with the date_time (together) "1/1/2012 9:56:53 AM" and employee_id. There are many swipes by each employee each day, but only need first and last for each employee.
Any suggestions for this fairly new person who is just learning how to provide this report?