I have an employee database setup that logs employee hours. I have a report that looks at each employees cost per week and that is compared to our practice income for the week.



I have a report that is setup with a few grouping levels date,clinic (we have two clinics), staff member.

In the detail section of the report are the employees daily hours worked for each shift (sometimes two shifts with lunch breaks). In the staff member footer I total the hours for the week. I have another control (calcovertime) in the footer that calculates out overtime worked.

That much works great. The problem I am having is to get a total of the calcovertime control in the clinic footer and then a grand total from both clinics in the report footer. I have tried just summing the controlcalc field but that produces an #error message. Any suggestions?