Cumulative Page totals

[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

 

[Marshall Barton]

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.

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.

 

[fredg]

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

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