#error with calculated field in report footer

[Spidey3721]

Can I use a calculated field in a report page footer?

I am trying to get a sum (textbox controlsource: "=sum([costs])" in the PAGE
FOOTER

But I'm getting a #ERROR

It appears as though I have the exact same setup that I have used on similar
FORMS - Also - When I cut and paste this sum textbox into the DETAIL section
of the report - it works, but it repeats with every COST that is listed - I
only want it at the bottom.

Also - Is there a way to break a report into sections, where I can have more
headers/footers ?

 

[Glen]

The same thing happened to me today. I had to go to the view menu and choose sorting and grouping and turn group footer on. I'm not sure if it will work for you or not, but it's worth a try

 

[Van T. Dinh]

Sum() doesn't work in the PageFooter!

If you want to have the Page Totals, you need to write VBA code for the
Report using the OnPrint Event (since page does not exist and therefore sum
does not exist until the OnPrint Event).

The technique is described in Topic 3.7 of the Access Cookbook by Getz /
Litwin / Baron published by O'Reilly.

 

[Yvonneb]

When report is in Design mode - View - Sorting/Grouping will let you have a
Header and/or footer for each grouping

YTB