I would like to do calculations in a form field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to program a field in a form so that if I need to do a
calculation like adding two or three dollar amounts and the total will
appear in the field. Just like in Excel
 
I would like to program a field in a form so that if I need to do a
calculation like adding two or three dollar amounts and the total will
appear in the field. Just like in Excel
Click to expand...

Add an unbound control to your form.
Set it's Control Source to:
=[FieldA] + [FieldB] + [FieldC]

The result will appear in the control. It will not, nor need it be, be
saved in any table.
 
Back
Top