If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Creating Expression (Formula)
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. |
Thread Tools | |
Display Modes | |
|
|