Totals on a report to be carried forward to next page

[reterrig]

I am quite new in the Access thefore I need some assistance. I have created a
report with a lot of pages. I need the totals of the 1st page to be carried
forward to the second page; to be calculated to the totals of the 2nd page;
to be carried forward and to be calculated in the totals of the 3rd page and
so on. The Source of the control box is an expresion in the relevant query.
Thanks a lot

 

[reterrig]

To clarify: The totals of the 1st page to be also printed on the top of the
next page;the totals of the second page to be printed on the top of the 3rd
page and so on

 

[fredg]

I am quite new in the Access thefore I need some assistance. I have created a
report with a lot of pages. I need the totals of the 1st page to be carried
forward to the second page; to be calculated to the totals of the 2nd page;
to be carried forward and to be calculated in the totals of the 3rd page and
so on. The Source of the control box is an expresion in the relevant query.
Thanks a lot

See Microsoft Knowledgebase article
132017 "How to sum a column of numbers in a Report by page."

 

[reterrig]

Fred,
Thanks for your valuable assistance. I have fixed part of my report. I have
managed to print the running sum to the bottom of each page. Now I need also
the running sum of the previous page to be printed also on the top of the
next page i.e.
1st Page Quantity
1
1
1
1...
Page Totals 4

2nd Page Quantity
Totals B/F 4
1
1
1...
Page Totals 7

and so on

 

[fredg]

Fred,
Thanks for your valuable assistance. I have fixed part of my report. I have
managed to print the running sum to the bottom of each page. Now I need also
the running sum of the previous page to be printed also on the top of the
next page i.e.
1st Page Quantity
1
1
1
1...
Page Totals 4

2nd Page Quantity
Totals B/F 4
1
1
1...
Page Totals 7

and so on

What is the name of the control in the Page footer that displays the
page total?
Let's assume it's name is [MyPageTotal].

Add an unbound text control to the Page Header.
Leave it's control source blank.
Name this control "MyHeaderTotal".

Code the PageFooter Print event:
Me![MyHeaderTotal] = Me![MyPageTotal]

That should be all you need do.

 

[reterrig]

Fred,

My report now works. Thanks for your assistance

Fred,
Thanks for your valuable assistance. I have fixed part of my report. I have
managed to print the running sum to the bottom of each page. Now I need also
the running sum of the previous page to be printed also on the top of the
next page i.e.
1st Page Quantity
1
1
1
1...
Page Totals 4

2nd Page Quantity
Totals B/F 4
1
1
1...
Page Totals 7

and so on

What is the name of the control in the Page footer that displays the
page total?
Let's assume it's name is [MyPageTotal].

Add an unbound text control to the Page Header.
Leave it's control source blank.
Name this control "MyHeaderTotal".

Code the PageFooter Print event:
Me![MyHeaderTotal] = Me![MyPageTotal]

That should be all you need do.