Sum a field in Report Footer

[Grandchester]

Hi there. I have a field called Qty on a report that contains some numeric value. I want to sum that value on the footer of the report. I have put a text box in the footer and for the Control Source I put
"=Sum([Qty])" (without the quotes). When I try to run the report it keeps prompting me for a value for the field. It is spelled correctly and everything, but it just doens't seem to be working. Any ideas? Thanks!!

 

[Rich]

Which footer?

 

[Grandchester]

The report footer. I need to sum the whole report. I put it in the page footer, but that gives me a value of #error.

 

[Pat Hartman]

If Qty is the name of a calculated control, you can't use it in a Sum() function. You need to re-do the calculation.

=Sum(fldA * fldB)

 

[Grandchester]

Thanks Pat. I got it working. Thanks for the help.