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
 

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

Back
Top