Sum function for calculated values

[slames]

I need to sum the contents of a textbox on a report. But the contents of this text box are calculated from other text boxes present on the report - the text box I want to sum contains a formula. How can I obtain this total?, at the moment it asks me to insert parameter value.

Thanks

Steph

 

[Aubs010]

Steph,

Say the control name with the formula is "SubTotal"

then in another control (called "Total&quot have: "=[SubTotal]" in the Control Source

Think that should do it.

Hope it helps

Aubs

 

[CosmoKramer]

Steph,

When computing a total with an aggregate function or formula you can't use the name of a calculated control in the Sum function. You must repeat the expression in the calculated control. So, repeat the calculation in your report footer.

For example, if the control you want to sum had:

 =[Qty] * [Price]

then the control source in your report footer would be:

=sum([Qty] * [Price])

 

[slames]

Yes, thank you. In the end I used a running sum in the text box and then in the report footer, referred to this text box and therefore obtaining the last value and the total.

Thanks for your help.

Steph