Calculate average between two text boxes on a form

G

Guest

Im trying to calculate average using the values of two text boxes in a form.
Its always giving error.
 
T

Tom Lake

B.Vijay Sarathi said:
Im trying to calculate average using the values of two text boxes in a
form.
Its always giving error.
Click to expand...

What kind of error? If it has #error in the average box, then one of the
controls referenced is wrong.
A mistake I sometimes make is to use the name of the control in the
calculation

control name: box1
control name: box2
control name: box3
box3 data source: =(box1 + box2) / 2

should work if box1 and box2 both contain numbers.

Tom Lake
 

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

Calculating an average on a form 2
Default value for a check-box 12
Average box in form 2
Calculate and Display an Average in a textbox 2
CLEAR MORE THAN ONE UNBOUD TEXT BOX BY CLICKING AN ACTION BUTTON 1
Using Between criteria to search query 1
Calculating a text box 9
calculates averages if not all questions are answered 4

Top