I have a MS Access Database that track products through 3 different departments. The report that I have groups items by Item, then by Department then by Operator. I have a calculated subgroup fields (in the department footer) that takes the 1. [SumOfQty] / [SumOfTime] and 2. [SumOfLaborCost] / [SumOfQty]
Now I want to get a grand total of these calculated fields in the Item Footer. But everytime that I try and reference the calculated field and run the report, it pops up asking for the parameter to be entered.
I have added two files to help explain.
How can I add the sub-groups total lines to a Grand total when they are a calculated field?