AnsweredAssumed Answered

Subsummary report by Employee showing total hours worked and total pay

Question asked by Phyllis on Sep 2, 2014
Latest reply on Sep 3, 2014 by philmodjunk

Title

Subsummary report by Employee showing total hours worked and total pay

Post

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?

Outcomes