Sum textbox in continuos form

[cuongmyh]

Hi!


How to sum a textbox in a Continuos form?
Sum locate in form footer.
Thank you

[lfpm062010]

If the textbox "Text0" and "Text2" are empty or Null, then the #error will show in textbox "Text4".

If on the same form,

=CDbl([Text0])+CDbl([Text2])

If not on the same form,
=CDbl(Forms![Form1]![Text0]) + CDbl(Forms![Form1]![Text2])

[Missinglinq]

...How to sum a textbox in a Continuos form...

If you're speaking of summing all of a single, given Textbox, such as the total of unit prices on an invoice Form

=Sum(Nz([NumericalFieldName],0))

Notice it says NumericalFieldName! It must be the name of the Field in the underlying Table, not the name of the Textbox...unless the names are the same.

If the Field in question is a Calculated Field, you have to sum the Fields involved in the calculation

=Sum(Nz([NumericalFieldName1],0) + Nz([NumericalFieldName2],0))

not the Calculated Field.

Linq ;0)>