I want the Max PM Start Time each day and the Max AM End Time the following day
This will then reach the shift worked starting with first acct worked start time and last account
worked end time. I want this for each day. I am looking for qry to do this in access as my data is stored in an access table.
There are multiple start and end times of svc I just want to see first of shift and end of shift.
So it looks like this.
Start Time: End Time: Hours Worked
11/8/10 10:10 PM 11/9/10 2:39 AM 4.23
11/9/10 7:52 PM 11/10/10 12:14 AM 4.22