sum in the page footer

[eRed]

Help

I know it's not normally done but I have a one page report that requires the total (sum) of a field - [EDS_total] - be at the bottom of the page.

I found a post on Microsoft's site but it is for a sum on every page's footer and it is for MS Access 2003. I am using MS Access 2007.

See the section named "Placing sums in the page header or footer"

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

I have placed "=Sum([EDS_total])" in the page footer, but of course I get "error"

Any help would be greatly appreciated!

Thanks,
Eric

 

[vbaInet]

Whether one page or multiple pages, the code is still the same.

Have you tried what was explained there? Always good to give things a try before dismissing it unless you fully understand it's functionality.