Subsummary report by Employee showing total hours worked and total pay
I need to run a payroll summary report each week that includes the Employee Name, total regular hours worked, total OT hours worked, total regular pay, total OT pay, and Total Pay.
I was trying to do this based on a TimeSheet table that I have which contains all of this information. The total hours and pay are calculated using a running total when sorted by employee id. What I need for my summary report is just the Employee name and the Final running totals. Do I need to create a different table to use for my summary report or can it be done using this TimeSheet table with running totals?