Subtotals for Grouped Fields in a Group Footer

[Guest]

I have made a report that is grouped and sorted within each group. I have
added a group footer to each (only 2 groups) and I would like to add
subtotals to each group and a grand total as well. The report pulls from a
query that is date-defined from a different form.

Thanks in advance for any help.

Austin

 

[Al Camp]

asaylor,
If you had a bound field on your report like [Cost], then a...
=Sum([Cost])
in the Group Footer would yield the total for that group.

=Sum([Cost])
in the Report Footer would yield the Total of all Costs (regardless of group).

 

[Guest]

Thanks Al - it worked like a charm.

asaylor,
If you had a bound field on your report like [Cost], then a...
=Sum([Cost])
in the Group Footer would yield the total for that group.

=Sum([Cost])
in the Report Footer would yield the Total of all Costs (regardless of group).

--
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

I have made a report that is grouped and sorted within each group. I have
added a group footer to each (only 2 groups) and I would like to add
subtotals to each group and a grand total as well. The report pulls from a
query that is date-defined from a different form.

Thanks in advance for any help.

Austin