CALCULATED CONTROLS

[maeling]

I have some calculated text boxes on my report that I would like to use in other calculations but when I run the report I am prompted to enter the vaues in a parameter dialog box. How can I over come this.

Example

TextA + TextB = TextC

=Sum([TextC])

I am unable to use TextC

 

[rileynyc]

sum([TextA]) + Sum([TextB]) should work

 

[BlaineR]

Hi,

I guess another option would be to calculate TextC within a query rather than using a text box. That way you could refer to TextC directly in any other calculated text boxes that you need.

rileynyc's answer is a lot simpler, assuming that your example is all you want to do. The query option would be more applicable if you've got equations that aren't so easily calculated using available fields.

B.