Group Totals in a Report

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

 

[Marshall Barton]

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)

 

[CDG via AccessMonster.com]

Thanks for your response. I will give a try tomorrow.

 

[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)