Cumulative Page totals

  • Thread starter Thread starter T Best
  • Start date Start date
T

T Best

Hi all,

I'm building a report and I need to have the Cumulative totals at the bottom
of each page. For example the first page would have a totals field for the
first page and the totals field for the second page would have totals for
the first page and the second page and so on. Can anyone point me in the
right direction? Any help would be very much appreciated.

TIA
Ted
 
T said:
I'm building a report and I need to have the Cumulative totals at the bottom
of each page. For example the first page would have a totals field for the
first page and the totals field for the second page would have totals for
the first page and the second page and so on. Can anyone point me in the
right direction? Any help would be very much appreciated.
Click to expand...


Use a text box in the detail section and set its RunningSum
property to Over All. Then, another text box in the page
footer section can just refer to the first text box.
 
Hi all,

I'm building a report and I need to have the Cumulative totals at the bottom
of each page. For example the first page would have a totals field for the
first page and the totals field for the second page would have totals for
the first page and the second page and so on. Can anyone point me in the
right direction? Any help would be very much appreciated.

TIA
Ted
Click to expand...

See Microsoft KnowledgeBase article:
132017 "How to sum a column of numbers in a report by page"
 
Back
Top