Sum() it up
If you would like to show a total in the footer or each page of a report, you may have a problem. Access does not allow the SUM() function in the footer.
The way around this is to put a SUM() function in an unbound text box in another part of the report.
Choose Properties and set the visible property of the control to No.
In the footer, create another control using the "calculation" text box as the ControlSource.
The Sum() function, as well as the other aggregate (totals) functions can reference only a field and not a control.
From the Microsoft Knowledge base:
How to Sum a Calculation in a Report
How to Display and Total Subtotals from Subreports
How to Print a Group Footer at a Specific Location
See all Topics