Another Text box sum in footer in Access report question 1

[hedgracer]

Another report with a different set of problems. This report has all the calculations in the Account Header (don't ask me why; I didn't write it) and the text box it is referencing is named net_repo and has the following calculation in it:

=Sum([Qty]-([ExistingTerm]-[NewTerm]-[OpenRolls])+[Overnight]

Most everyone will be quick to pick up that the sum is not necessary but that is indicative of all of the reports in this database. Anyway, I have a number of Footers that I tried to put the following calculation in a text box in:

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

When I run the report I get a run time parameter value box asking for a net_repo entry. I have tried setting up a separate text box in the Account Header and having the value of the net_repo populate it and reference that text box but I still get the same parameter value box at run time. I also have tried putting the entire calculation (less the sum) into the above calculation in the footer but that results in multiple run time parameter value box questions. What am I doing wrong (besides not rebuilding the report which is not an option)? Any help is appreciated.

Dave

 

[dhookom]

Is the answer here exactly the same as your question I just anwered in your previous thread?

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

Sum the expression, not the text box name.

Duane
Hook'D on Access
MS Access MVP