F

#### fireytech

and overtime hours of all employees for pay period "x". I know how to

set up a parameter for the underlying query to ask me which pay

period. I can generate the Total Hours sum easily but I don't know

how to get the report to calculate regular and overtime hours as a

total for all employees. The query/report would have to calculate the

individual employees overtime and then sum it because not all

employees work 40 hours a week so I can't just multiply 5 employees x

40 and subtract it from the total hours.

I keep all the time sheet entries in a table called

TBL_TimesheetTimes. There is one line for each in/out. The table has

fields called EmployeeID, PayPeriodEndDate, WeekEndDate, WorkDate,

TimeIN, TimeOut, & DailyTotalHours.

We have to calculate overtime on a weekly basis (if the employee works

79 hours for the pay period but 60 hours were in one week, we have to

pay 20 hours overtime).