Adding a text box value

[Darla123]

Good morning everyone!
I have a report that has a text box called "Reserve" whose control source is from a query, so based on a bunch of different things, the value on the text box is different on every page on the report. I am trying to add another text box that adds up all the different values in "Reserve". I've tried using "=Sum([Reserve])", I've tried using running sums in the properties, and all that ever happens is that it pulls the first value on the first page of "Reserve" and ignores the rest. What is the best way to accomplish this? Am I going down the wrong path trying to use the Running Sum property?:banghead:

 

[Minty]

Have you put the text box in the header/footer or detail ?

 

[Darla123]

Well, the "reserve" text box is in a section we have called "flag1 footer". I've tried it there. The total box needs to be in the report footer, but I can't get it to sum correctly no matter what section I put it in.

 

[Minty]

Is reserve already a sum on the form or in the underlying query ?

 

[Darla123]

It comes from the underlying query.

 

[Minty]

Try adding your Reserve as another hidden control in the detail section and try summing that as a running sum?

 

[arnelgp]

in your query is reserved converted to numeric?