Trouble with Summing in Footer

M

MarcS

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
 
S

sdcarrig

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.
 
M

MarcS

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

sdcarrig said:
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.


MarcS said:
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
Click to expand...
Click to expand...
 
Top