=sum([fieldnumber]) in page footer in Report. 1

[budich]

I realize this is a dumb question, but I am really want to know how to put a sum per page in Access 97. What I found when I move the =sum([fieldnumber]) in page footer in report, always appear "error". I can put it without error in report footer but it sum up until the end of report or end of pages. Thank you in advance

 

[mark01]

In the Design View, if you change it from a "Page Header/Footer", to a "Report Header/Footer", it shouldn't give you that error anymore.

 

[mark01]

Oh, I just read the rest of your question. I answered something you already knew, sorry.

 

[nomus1]

Have you tried creating a text box that is a running sum.
Make this field invisible and on the page footer have a field that =(running sum field name)?

 

[budich]

Yes !!!, finally I found the answer after "no way out" in sum([field]), Thanks alot Nomus1. Cheers