Page Sub Total

[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.

 

[Allen Browne]

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.