Text box sum in footer asking for Parameter value 1

[hedgracer]

Let's just say I have never ran into this before and have been doing access reports a long time. Also, this is not my report and there is no documentation. I have a Label9 Header and a Label9 Footer with detail between them. I have inserted the following text box formula in the detail:

=IIf([Qty]<0,[Qty]*-1*0.25,[Qty]*0.25)

This text box is named DetailCharge. In the Label9 Footer I have made a SumCharge Text Box that has this formula:

=Sum([DetailCharge])

Every time I run this report the report asks for a parameter value for DetailCharge. If I do not have the SumCharge text box in there it does not ask for this parameter value. This is in Access 2003 running on a Windows XP box (Yep, you heard that right). What the heck am I doing wrong? Any help or suggestions is appreciated. Thanks

Dave

 

[dhookom]

You can't sum a text box from one section to another. Try:

=Sum(IIf([Qty]<0,[Qty]*-1*0.25,[Qty]*0.25))

Duane
Hook'D on Access
MS Access MVP