footer totals

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

Guest

I'm writing a pilot logbook database and have about 500 records of flight
time, landings, instrument approaches... My report shows 20 records per page
by Date. I want to total "flight time" for example for each report page,
then forward that to the next page where it will be added to that pages
totals, and so on. I'm having a hard time totaling numbers per report page,
much less forwarding numbers to the next page... Help.
 
Best approach I've seen to totals in footers used an "invisible" running sum
control in the detail, and did a little arithmetic in code to subtract the
total from the previous page. You have to write your code either to take
into account or not be affected by the fact that footers, like other
sections, have events Format, Retreat, and Print that may fire more than
once when the record is displayed.

The only footers with which the builtin functions work nicely are Group and
Report footers. I suppose they figured that most people would only use Page
Headers and Footers for identification, not totalling -- so it isn't as easy
with Page Footers.

Larry Linson
Microsoft Access MVP
 
Back
Top