Report - Add Hours From Date

[TechNat]

Anyone have any ideas on how to get the sum of hours for each week in the report?

I can get the sums of hours for the employee, but I need it to break down into each week on the report

There are different earning codes that need to be summed up for each week.


Employee Name
Week #1 Total Hours - 80
01 Regular 40
07 Vacation 40

Week #2 Total Hours - 80
01 Regular 40
07 Vacation 40


This is what it needs to look like.

All the info is being pulled from a query also.

Thanks for the help!

 

[Pat Hartman]

Add a grand total in the report footer section. The expression in the control should be identical to the expression in the week footer.