page totals

[Glen]

Is there a simple way to have a sum of a numeric field per page? I've
developed a workaround but it is really cumbersome. I print from 1 to 6
detail lines per page and would like to show a total in the page footer for
just that page... I don't want a running sum.

Right now I have to run a routine to group the records in groups of 6 or
less and assign each a subgroup code... etc. It works but would love a
simpler solution... i.e. have a calculated field in the page footer that is
the sum of the page footer. The problem with doing it in a group footer is
that the group footer floats and the page footer needs to be at the bottom
(think hcfa form).

I am on Access 2007.

My thanks in advance for anyone that can suggest a simple solution.

 

[Marshall Barton]

Is there a simple way to have a sum of a numeric field per page? I've
developed a workaround but it is really cumbersome. I print from 1 to 6
detail lines per page and would like to show a total in the page footer for
just that page... I don't want a running sum.

Right now I have to run a routine to group the records in groups of 6 or
less and assign each a subgroup code... etc. It works but would love a
simpler solution... i.e. have a calculated field in the page footer that is
the sum of the page footer. The problem with doing it in a group footer is
that the group footer floats and the page footer needs to be at the bottom
(think hcfa form).

I am on Access 2007.

You need an (invisible?) running sum text box (named
txtRunAmount) in the detail section. You also need an
invisible scratch pad text box (named txtPageRunTotal) in
the page footer.

Then add code like this to the (invisible?) report header
section's Print (or Format) event:
Me.txtPageRunTotal = 0

and this kind of code in the page footer Print (or Format)
event:
Me.txtPageAmt = Me.txtRunAmount - Me.txtPageRunTotal
Me.txtPageRunTotal = Me.txtRunAmount

 

[Allen Browne]

You can use the events of the report sections to sum the values for the
page. Here's how:
Reports: Page Totals
at:
http://allenbrowne.com/ser-11.html

Note that this works in Normal and Print Preview only (not Report or Layout
view.)