Trouble with Summing in Footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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.
 
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...
 
Back
Top