totals for each page

[ggreg]

Is there a way to code a text box that when you get to the end of the page to show totals for that page
which mean every page will show totals just for that page.

eample let say for page one there were 21 records and one field the data
total 20

then on page two there were 35 records and the same field total 50 ......
the first page because of header information will have less records but all other pages should have above the same number of records
so can any one help with this problem?
my question again is...Is there a way to total records by what is shown on
the page and then in that text at the bottom to display that total
Thanks

 

[ggreg]

found a solution:

http://support.microsoft.com/kb/132017

but thanks to all who looked at this!