adding and displaying field summary in a report

D

Dan

Access2002/W-XP
I have a report that lists flavors of ice cream ordered each month.
At the end of the report I would like to list the flavors for the total
period and the total ordered; ie.,
Choclolate 6
Vanilla 9
Any suggestions appreciated!!!
Thanks,
Dan
 
D

Duane Hookom

I expect you could create a totals query similar to your report's record
source. Then use this totals query as the Record Source of a subreport to
place in your main report's Report Footer section.
 
Top