Page totals

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

I have a report that has multiple columns. What I would
like to be able to do is at the bottom of eac page, have
a sum of the entries for that page. I am using Access
2000 and have tried using the follwoing documents form
the Support.microsoft site, 216311 and 296249 which seems
to ahve replaced the 210261. When I use either of these
methods the result is a running sum over the entire
document.
 
Hi Chris!

I don´t know how your report is set up, which grouphead/foot and so on but
have you tryed to create a pagefooter and place the control there and put
code simular to this (see below) in the texbox rowsource:

=Count([YourTableOrQueryName].[FieldYouWantToCalculate])

// Niklas
 
The idea in article 216311 works, are you certain you've reset your sum
variable to 0 within the page header's format event???

HTH
Sam
 
Back
Top