How to sum a value from a text box with a name of "Txt999"

[bethabernathy]

Hi - I am having a little trouble. I have a calculated field on the footer of a report. The field is a text box containing the following syntax:

=Sum([Txt999])

I want it to sum the value in the text box in the report named "Txt999". When I run the report it prompts me to enter a Parameter Value for "Txt999". I have gotten these types of calculations to work before, but for some reason I am missing something with this one.

Any help is really appreciated. Thanks, Beth beth@integratedresourcemgmt.com

 

[pdldavis]

Hi, one way to go about this is to start in the report detail section, assuming this is where text999 is. Copy text999 to say, txt1000 - the control source is the same. Change txt1000 running sum to Over Group and set the format property to invisible.
Change the control source of the text box in the footer to:
=[txt1000]. No Running Sum on this one.
That should do it