Unanswered: display last page total ) in the next page header of a report
I have a simple table with many columns and in my report I am using hidden text field to calculate running sum for that columns in the footer.
Now, is there a way to show the sum (total) of the previous page in the header section of a new report page and how can I achieve this?
... I tried to put just running sum text box in the header section, as Access calculates header before the body and footer of a report to show last page, but it displayed last page's sum + 1st record of a table... I don't know how to get rid of this, but I beleive it's not right way of doing it, is it?
Last edited by marrio; 11-05-04 at 10:01.
Reason: I accidentally post the topic before actually finished it