How do you Sum a calculated field????

[PQTIII]

If have this field that shows (tons) based on other fields:


=IIf([patterntype]="Production",(([spacing1]*[spacing2]*[depth])/13.5)*[totalholes],IIf([patterntype]="40' 4 Row 8x8",988*[totalholes],IIf([patterntype]="40' 4 Row 5x5",763*[totalholes],IIf([patterntype]="40' 3 Row 8x8",821*[totalholes],IIf([patterntype]="20' 3 Row",295*[totalholes],336*[totalholes])))))

I use this in a report to show the number of tons for each blast. At the end of the report I would like a total number of tons for all blasts, but I have no clue how to do this in the report footerwith a calculated field. Please HELP!!!

Thanks Paul

 

[Lilliabeth]

Is this what you mean?

In the report footer, put a text box with this control source:

=sum([PaulsCalcControlName])

 

[Remou]

ACC2000: How to Sum a Calculation in a Report

http://support.microsoft.com/default.aspx?scid=KB;EN-US;208850

(ACC2000: You Cannot Sum Calculated Controls in Forms or Reports

http://support.microsoft.com/default.aspx?scid=KB;EN-US;207763)