View Full Version : Footer Formula


rschultz
08-28-2001, 02:12 PM
in the Detail band of my form I have =[NWT]/2000 in a textbox called Text19 and that works. Then in the footer I have =Sum([text19]) but I get #Name? What am I doing wrong?

Pat Hartman
08-28-2001, 05:52 PM
You need to repeat the calculation. You cannot reference the control here.

=Sum([NWT]/2000)

rschultz
08-29-2001, 06:51 AM
that was it. I thought is was probably something simple. Thanks