Help! Multiple sub-totals by group in report

[Guest]

I am trying to create a report that purely displays subtotals based on
different groups. I have a query of activities that includes fields in each
record of Region, Channel and Cost Type (there are more, but this should be
enough to illustrate). For instance:

QUERY
[Activity Name] ... [Region] [Channel] [Cost Type] [Cost]
Activity 1 ... Region A Channel C Cost Type B $1,000
Activity 2 ... Region C Channel A Cost Type A $1,500
Activity 3 ... Region A Channel B Cost Type A $750

The report would show:
Region A $1,750
Region B $0
Region C $1,500

Channel A $1,500
Channel B $750
Channel C $1,000

Cost Type A $2,250
Cost Type B $1,000

Can this be done directly in a report (via sub-reports?), or would I have to
create multiple queries to total each group, then bring those each in
separately to a report? (I have tried using the sub-reports by using a SUM
function in the group footer, but I'm having issues with multiple records
showing up and my eyes are starting to go cross-eyed)

I'm relatively new to Access, and any and all help would be greatly
appreciated!

 

[Guest]

I am trying to create a report that purely displays subtotals based on

different groups. I have a query of activities that includes fields in each
record of Region, Channel and Cost Type (there are more, but this should be
enough to illustrate). For instance:

QUERY
[Activity Name] ... [Region] [Channel] [Cost Type] [Cost]
Activity 1 ... Region A Channel C Cost Type B $1,000
Activity 2 ... Region C Channel A Cost Type A $1,500
Activity 3 ... Region A Channel B Cost Type A $750

The report would show:
Region A $1,750
Region B $0
Region C $1,500

Channel A $1,500
Channel B $750
Channel C $1,000

Cost Type A $2,250
Cost Type B $1,000

Can this be done directly in a report (via sub-reports?), or would I have to
create multiple queries to total each group, then bring those each in
separately to a report? (I have tried using the sub-reports by using a SUM
function in the group footer, but I'm having issues with multiple records
showing up and my eyes are starting to go cross-eyed)

I'm relatively new to Access, and any and all help would be greatly
appreciated!

One other note: I can create the subtotals for each group in individual
reports (by group.) However when I try to use one of these reports as a
sub-report it splits the data up and gives duplicates (so Region A and Region
B will appear separately, and their totals will show up multiple times in the
report.)

Maybe I'm missing something easy here, but it's starting to drive me crazy...

 

[Duane Hookom]

Create a totals query for each "different groups". Then create a report for
each totals query. Then add each of these subreports as subreports to an
unbound main report.