Page Sub Total

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

Guest

I have the code to perform this, however, the page subtotal is adding
everything on that page, but also picking up the first value on the following
page, therefore inflating the actual page subtotal. Has anyone had this
problem and what did they do to solve it.
 
That can happen where you are using the section's events to collect the
total for the page. Particularly where sections Can Grow or Can Shrink or
must Keep Together, Access can take a shot at putting it on the page only to
discover it does not fit. The events fired (and so your code accumulated the
total), but Access back-tracked.

No promises, but you might be able to use the Retreat event to subtract the
amount form your accumulated total.
 
Back
Top