Page Footer calculated field

[rkgreen25]

It's been a very long time since I've used Access and am now trying to get back into some simple development. I am needing to create a calculated field that will total 3 fields of my report at the bottom of each page of the report. I am using Access 2010 and creating for web use.
Thank you for your assistance.

 

[vbaInet]

I don't use web reports but I don't think the web database in Access allows you to write VBA because that's what you need to sum in the footer of a report. I think Data Macros is the only thing you can use. Here's the code you would normally use to sum in the Page Footer (or Header):

http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx

... under the section 'Placing sums in the page header or footer'. See if you can translate that to Data Macros.