Continous form, calculated total field in footer?

[Snecia]

Hi there,
I have a form that is displayed continuously and there is a text field in it (Text12).
In the footer of this form I would like to add a textbox that is the sum of all Text12's on the form.
I tried =Sum([Text12]) in the textboxes control source but that is just displaying an error when I run the form.

Thank you for your time!

 

[spikepl]

text field in it (Text12)

How exactly do you propose to calculate a sum of texts?

 

[missinglinq]

...there is a text field in it...

As spike said, how do you expect to do math with a 'text field?'

Assuming that that was a typo, and the Field is actually a Number Field, it would appear that you're using the name of the Control on the Form, and you need to use the name of the Field the Textbox is Bound to.

=Sum([FieldName])

Also note that you cannot use SUM() against a Calculated Field, you must use it against the Expression, itself. For instance, if

FieldC = FieldA + FieldB

You cannot use

=SUM([FieldC])

You must use

=SUM([FieldA] + [FieldB])

Linq ;0)>