How to calculate subtotal for each page?

  • Thread starter Thread starter Lulu
  • Start date Start date
L

Lulu

I have posted a similar question earlier. I want to print
a report that shows a subtotal in the page footer section
and a grand total in the report footer section. How can I
calculate subtotal for each page?

Thanks for anyone who responds.
 
By the way, no grouping necessary on my report. It is
simply a long report that has many pages!
 
Use a Running Sum (OverAll) Control for the Amount (it can be invisible, and
in addition to the visible control where you show the actual amount). In the
Page Header's Print event, save it; in the Page Footer, subtract that from
the current Running Sum, and that should be the total for the page.
Depending on how events fire (I don't remember from the last test I did of a
solution like this), you may have to save in some other places, too. In the
Report Footer, you can just use the Sum function, or move the value from the
final Running Sum into the Total Control.

Larry Linson
Microsoft Access MVP
 
See Microsoft KnowledgeBase article:
132017 'How to sum a column of numbers in a report by page'
 
Back
Top