Two IIF statements possible?

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

I have a text box on my report that can have 3 different results depending
on the situation. The first 2 situations are as follows
=IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+[Text101]) This
works fine with the 2 possibilities, but I have a third situation of when a
check box is checked on my form (True). If the checkbox [Retest] is
checked, I need to have the previous IIf statement to have a result of 0.
Something like:
IIF([Retest]=True,0,IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+
[Text101]) I know this is not a correct statement, but what would be a
correct statenment? Thanks...Randy
 
That did it, Thank you...Randy
Douglas J. Steele said:
Very close. All you're missing is an additional closing parenthesis.

--
Doug Steele, Microsoft Access MVP

(No private e-mails, please)



Randy said:
I have a text box on my report that can have 3 different results depending
on the situation. The first 2 situations are as follows
=IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+[Text101]) This
works fine with the 2 possibilities, but I have a third situation of
Click to expand...
when
a
check box is checked on my form (True). If the checkbox [Retest] is
checked, I need to have the previous IIf statement to have a result of 0.
Something like:
Click to expand...
IIF([Retest]=True,0,IIf([Text97]+[Text99]+[Text101]<50,50,[Text97]+[Text99]+
[Text101]) I know this is not a correct statement, but what would be a
correct statenment? Thanks...Randy
Click to expand...
Click to expand...
 
Yes, you can use the statement that you have; just add
another ) bracket at the end and it will worked.
 
Back
Top