Group Totals and Grand Totals on each page

[Ken Monk]

I have a grouped report with totals for each group. I print each group on it's own page to gove to the leader of that group. I would also like to give them grand totals so they may compare their group to the whole. Is there a way to get Grand Totals to appear on each page along with group totals?

 

[Access Developer]

If you have group totals in the Report Footer that are calculated directly,
and not from the Group totals, you can try referring to those Report Footer
totals in your Group Footer. That _may_ force the report to be run through
twice to calculate the Report Footer totals, and then again to fill the Text
Box control for grand totals in the Group Footers.

I don't recall doing exactly what you describe (but, hey, I might have
forgotten that), but you can, with cleverness and thought, do some
surprisingly unobvious things with Access Reports, which, on first look, may
seem very simple and limited.

--
Larry Linson
Co-Author, Microsoft Access Small Business Solutions, Wiley 2010

I have a grouped report with totals for each group. I print each group on
it's own page to gove to the leader of that group. I would also like to
give them grand totals so they may compare their group to the whole. Is
there a way to get Grand Totals to appear on each page along with group
totals?

 

[Ken Monk]

Amazingingly simple solution. I just reference the total fields from the report footer and I have the solution. Thank you for pointing me in the right direction.

 

[Access Developer]

Always glad to help with Access when I can . . . been doing it since 1993.