Trouble with Summing in Footer

[Guest]

I have 2 levels of grouping for which I want totals. They lay out as follows:
Header -Month
Header - Facility
Detail - Total Minutes by CallZone
LOCAL 120
LDIST 200
Footer - Facility
Sum of minutes for a facility
Header - Month
Sum of minutes for ALL facilities for the month
Sum of all LOCAL minutes for this Month
Sum of all LDIST minutes for this Month

How do I get the last two sums in the Header - Month without doing a
sub-report and seperate query?

Any advice is appreciated

Marc

 

[Guest]

You need two summing fields in the report form.

For each, in Data Control Source (Properties for the summing report field)
type:

=Sum(IIf([CALLZONE]="LOCAL",[MINUTES],0))

=Sum(IIf([CALLZONE]="LDIST",[MINUTES],0))

Insert the appropriate label next to each. You can repeat these at each
grouping level.

 

[Guest]

Bingo. Thanks you very much...especially for such a quick response!

You need two summing fields in the report form.

For each, in Data Control Source (Properties for the summing report field)
type:

=Sum(IIf([CALLZONE]="LOCAL",[MINUTES],0))

=Sum(IIf([CALLZONE]="LDIST",[MINUTES],0))

Insert the appropriate label next to each. You can repeat these at each
grouping level.

I have 2 levels of grouping for which I want totals. They lay out as follows:
Header -Month
Header - Facility
Detail - Total Minutes by CallZone
LOCAL 120
LDIST 200
Footer - Facility
Sum of minutes for a facility
Header - Month
Sum of minutes for ALL facilities for the month
Sum of all LOCAL minutes for this Month
Sum of all LDIST minutes for this Month

How do I get the last two sums in the Header - Month without doing a
sub-report and seperate query?

Any advice is appreciated

Marc