Calculating fields

  • Thread starter Thread starter Robin
  • Start date Start date
R

Robin

I need a formula for adding and subtracting totals from
differant fields on the same form.
Thank You
 
Hi

Create an unbound text box to display the result. Set its
Control Source to:

=[TextBox1]+[TextBox2]-[Textbox3]*[TextBox4]

where [TextBox1] etc are the names (look in the Properties
to get this) of the controls on the form holding data you
want to calculate from, and obviously I just used +, - and
* as examples. You know what the expression should be.

Cheers

David Cleave

www.logistics.nhs.uk
 
Back
Top