467,166 Members | 1,021 Online
Bytes | Developer Community
Ask Question

Home New Posts Topics Members FAQ

Post your question to a community of 467,166 developers. It's quick & easy.

Page footer with page total and previous page total

I know the basics about access reports and putting page totals in the
page footers. What I can't figure out is along with the current page
total to display the previous page total:

At the bottom of every page:

Page 1 page footer:
Total brought forward= $0.00
Current Page total = $100.00
Grand Total= $100.00

Page 2 page footer:
Total brought forward= $100.00
Current Page total = $75.00
Grand Total = $175.00

Page 3 page footer
Total Brought forward= $175.00
Page Total= $20.00
Grand Total= $195.00

How can I get the the previous page total to display if the code
automatically resets
the page total to zero when it draws the next page?
Here is the code for doing the page totals in the page footer:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
txtPageCashSum = txtPageCashSum + txtDonorCashAmmount
txtPageCheckSum = txtPageCheckSum + txtDonorCheckAmmount
End Sub
Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As
Integer)
txtPageCashSum = 0
txtPageCheckSum = 0
End Sub


page tw$

Aug 7 '06 #1
  • viewed: 5813
Share:
1 Reply
In the properties of the previous page total field, set running sum = yes.

"CaptainDahlin" <ka**@thedahlins.netwrote in message
news:11**********************@m79g2000cwm.googlegr oups.com...
>I know the basics about access reports and putting page totals in the
page footers. What I can't figure out is along with the current page
total to display the previous page total:

At the bottom of every page:

Page 1 page footer:
Total brought forward= $0.00
Current Page total = $100.00
Grand Total= $100.00

Page 2 page footer:
Total brought forward= $100.00
Current Page total = $75.00
Grand Total = $175.00

Page 3 page footer
Total Brought forward= $175.00
Page Total= $20.00
Grand Total= $195.00

How can I get the the previous page total to display if the code
automatically resets
the page total to zero when it draws the next page?
Here is the code for doing the page totals in the page footer:

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
txtPageCashSum = txtPageCashSum + txtDonorCashAmmount
txtPageCheckSum = txtPageCheckSum + txtDonorCheckAmmount
End Sub
Private Sub PageHeaderSection_Print(Cancel As Integer, PrintCount As
Integer)
txtPageCashSum = 0
txtPageCheckSum = 0
End Sub


page tw$

Nov 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

1 post views Thread by Andy V | last post: by
1 post views Thread by kaosyeti@comcast.net via AccessMonster.com | last post: by
2 posts views Thread by CaptainDahlin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.