Adding sub-group totals in report footers

[AshikHusein]

I am trying to create this report which is grouped by "Que" and then within "Que" it is grouped by "Acct Type" (report is extracted from a Query and looks something like this as an example).

Toy Que
A 8

B 10

Food Que
A 15

B 30

where Toy que and Food Que belong to the main group and "A" and "B" belong to the sub -group within the main group. I would like to total the sub-group in the report footer section so that for the above example it shld be displayed as follows i the report section:

A 23

B 40
Could anyone tell me how this can be done? Thanks.

 

[AshikHusein]

How do I link a second query to a report?

Thank you for the reply. I have already made most of the reports which have pretty involved calculated fields. If I make a different query just for the group totals how do I also link the new query to the same report? I can't seem to find a way to link a second query to the report after initially choosing only one query for the report.

 

[AshikHusein]

Thank you Pat. I am not very familiar with access but your response leads me on to something which I will research and learn as to exactly how it can be done. Thanks again.