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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Struggling with Calculated Field on Form to Main Form/Table 2
Need help on how to pass calculated field from a form to another form 0
Testing performance on a form 5
Calculated Field in Form 3
Calculating a text box 9
Field Doesn't Show any Data for User 3
Creating a calculating control on an Access form 4
calculated field in form - to table 2

Back
Top