Group Totals and Grand Totals on each page


K

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?
 
Ad

Advertisements

A

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?
 
K

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

Advertisements

A

Access Developer

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top