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:
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: