syntax for 'Or'

[Guest]

In my report I am trying to add two conditions to IIf statement using Or.
What is the right syntax. I am trying someting like:

IIf(Or(condition1,condition),result1,result2)

or

IIF((condition1 or condition2),result1,result2)

but it does not work. Any suggestions ?

Alternative solution is to add those conditions to the query which the
report is based on but I am trying to do that directly in report.

Thanks for advice.

Tony

 

[Ken Snell [MVP]]

IIf(Condition1 Or Condition2, ResultIfTrue, ResultIfFalse)

 

[Terry]

Tony

iif(condition1,result1,iif(condition2,result1,result2))

HTH

Terry