weekly reports by shift

  • Thread starter Thread starter Kathy
  • Start date Start date
K

Kathy

Is there a way to get totals of various fields in a weekly
report by shift?

For instance, 1st shift would be from 6:00 am to 2:00 pm,
2nd shift from 2:00 pm to 10:00 pm, 3rd shift from 10:00
pm to 6:00 am.

Kathy
 
Assuming you have the shift in your existing table. One
way would be to create a table called SHIFT. The two
fields would be Shift and Shift number

Shift Number Shift
1 6:00 am to 2:00 pm
2 2:00 pm to 10:00 pm
3 10:00 pm to 6:00 am

In you report query join atn the shift times. In your
report group by shift number. Have a shift number footer
and put your totals in there

Jim
 
Back
Top