Totals in Report Footer to be printed on same page as last group

[Wendy]

I'm sure this is a simple question with a simple answer, but can't think why
I can't see a previous response to this.

I have a report, it has a report header,page header, grouping header,
detail, group footer, page footer, report footer.

There is a force new page after group footer so each group is on a separate
page. At the end of the last group, I would also like to include the report
footer total.

Is this possible?

Thanks

Wendy

 

[Ofer Cohen]

In the Report Footer create a text box, and in the ControlSource of it write

=Sum([Field Name In The Table You Want To Sum])