Creating Expression (Formula)

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
--
Kind regards
Noëlla


"Nirav" wrote:

> 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.