Calculate average between two text boxes on a form

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

Guest

Im trying to calculate average using the values of two text boxes in a form.
Its always giving error.
 
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
 
Back
Top