Creating Expression (Formula)

  • Thread starter Thread starter Nirav
  • Start date Start date
N

Nirav

Hi,

I have created forms by using the Wizard from table.

In form there are two comboboxes named"Biceps" and "Elbow" and one textbox
"Total" . Now for example, if score of "Biceps" is 2 and score of "Elbow" is
3 then "Total" of values should be 5.

How can I creat a formula (Expression) that automatically adds value from
field "Biceps" and "Elbow"?

Please help.
 
Hi Nirav,

the answer is simple: add a new unbound textbox on the form and set its
control source property as follow:
= Nz([Biceps];0) + Nz([Elbow];0)
The Nz function is aded to suppress the emty value Null because Null +
anyting = Null
 
Back
Top