If then

  • Thread starter Thread starter CAKDH
  • Start date Start date
C

CAKDH

i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box is
no then value is 0.00? what would be the expression?
 
CAKDH said:
i have a calculated field that is optional with a check box above. can i
have an if the check box is yes then do the calculation if the check box
is
no then value is 0.00? what would be the expression?
Click to expand...


Something like

=IIf([chkYourCheckBox], <your calculation here>, 0)
 
You will need to put that code in the OnCurrent event of the form and
in the afterupdate event of the checkbox.

Ron
 
Back
Top