How to print the sum of the previous page

[budich]

Hi Guys,

Does anyone know how to print a SUM OF THE PREVIOUS PAGE ? For example :
Page 1 :
Part description value
Part A 10
Part B 20
Part C 30
Total 60

Page 2 :
Total from previous page 60
Part D 10
Part E 20
Part F 50
Total 80

So in this example I want the sum of “value” field (in this example = 60) also be printed in the top of page 2, the sum of page 2 (=80) can be printed in top of page 3 etc.
Thank you in advance
Budi

 

[DougP]

I suppose this is a report???

Put a new text box on the report and put this in it

=IIf([Page]=1,"",[sumtextbox])

Now you need to have the sum text box in a Group footer or you will end up with a total of the whole report.

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[budich]

Hi Doug,

Thank you for your help, I am sorry cannot get back to you soon.
Yes, this is for a report that has records more than 1 page and the reader of the report want to see the sum of every page and the continuity of the sum in the next page.

you said "Now you need to have the sum text box in a Group footer...", is it means it can give me the sum in every page ? What I have tried I put =sum[field name] in report footer but when I put it in page footer it shows error.
I am waiting for your help, thank you in advance.