Summary by Page?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to do a summary listing each page number with a field total
next to it?

Ex:

Page 1 $5,655.78 (page total from first page)
Page 2 $1,205,99 (page total from second page)

Thanks in advance for any assistance you can provide.
 
Yes, you can do this.

One way to accomplish it is to include in the detail section a control with
the Control Source of the field containing the Amount. Set that Control's
RunningSum property to "Over All". Capture the value from that RunningSum in
the OnFormat or OnPrint events of the Page Footer. Use the last-saved and
current values to calculate the value for the current page.

Larry Linson
Microsoft Access MVP
 
Back
Top