Group Totals in a Report

  • Thread starter CDG via AccessMonster.com
  • Start date
C

CDG via AccessMonster.com

I would like to have separate grand totals for 2 groupings in a report. The
groups are sorted in the grouping/sorting section and they have a
header/footer. Each group totals in the group footer and there is a grand
total for ALL sections. I would like to have a grand total for both section
A and section B displayed in the report footer.

Any help would be appreciated.
 
M

Marshall Barton

CDG said:
I would like to have separate grand totals for 2 groupings in a report. The
groups are sorted in the grouping/sorting section and they have a
header/footer. Each group totals in the group footer and there is a grand
total for ALL sections. I would like to have a grand total for both section
A and section B displayed in the report footer.


Summary totals like that are best done in a subreport. The
subreport's record source would be a Totals type query gased
on the query you used as the main report's record source.

A quick and dirty (maintenance headaches) is to use
expressions like:
=Sum(IIf(sectionfield = "A", amountfield, 0)
 
C

CDG via AccessMonster.com

Thank you. I created this calculated field in the Report and if worked!

CDG
Thanks for your response. I will give a try tomorrow.
[quoted text clipped - 9 lines]
expressions like:
=Sum(IIf(sectionfield = "A", amountfield, 0)
 

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

Top