put group footer into page footer in access report

[Guest]

trying to put group footer into page footer in access report as printing on
preprinted stock and need to totals in specific boxes ie group footer on last
page of group instead of page footer every page.

 

[Allen Browne]

Haven't test this, but you might try adding unbound text boxes to the Page
Footer.

Leave the bound boxes in the Group Footer. (You can set the group footer's
Visible property to No so they don't print.) In the Format event procedure
of the group footer, assign values to the unbound boxes from the hiddent
boxes in the group footer.

For example if Text0 is the unbound text box in the page footer, and
txtSumOfAmount is the text box that has the total in the group footer, you
add this line of code to the group footer's Format event procedure:
Me.Text0 = Me.txtSumOfAmount
and so on for other boxes.

Then use the Print event of the Page Header to clear the boxes, so they
don't show on following pages where a group is more than one page long:
Me.Text0 = Null