Syntax Error

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can someone tell me the correct syntax for what I am trying to do below?

=IIf(([C5_1A]=3) Or ([C5_1A]=18) Or ([C5_2A]=3) Or ([C5_2A]=18) Or
([C5_3A]=3) Or ([C5_3A]=18) Or ([C5_4A]=3) Or ([C5_4A]=18) Or ([C5_5A]=3) Or
([C5_5A]=18]) Is Null,"","What are all the prescription drugs, if any, that
you have taken in the past 6 months to help manage your depression?")

Thanks
Bill
 
Remove "Is Null". If *any* of those 10 expressions evaluate to True you'll
get an empty string. If they are all False then you'll get your question.

If you want to test for Null (which I don't think you do), use
IsNull([C5_1A).
 
Back
Top