Please help! I have a table which contains truck driver logs. It records the hours worked by each driver each day by recording their clock in/out times. A query puts these clock hours into 1/4 hr totals.
My delimma is that I need the calculate the total hrs. worked:
1. the last 6 days
2. the last 7 days
3. totals of 1 and 2 from 70 (Hrs avail tomorrow)
These need to be in sequential form
How can I group these records so these calculations can be done?
My delimma is that I need the calculate the total hrs. worked:
1. the last 6 days
2. the last 7 days
3. totals of 1 and 2 from 70 (Hrs avail tomorrow)
These need to be in sequential form
How can I group these records so these calculations can be done?
