Hi. Each condition that is being ORd has to be set out in full. You cannot shortcircuit this by leaving the condition to the end. The Access in-line IIF statement nearest to what you ask would be:
- IIF(([a] > 1) OR ([b] > 1), "Yes", "No")
The OR in this case is an operator, like any other operator such as + or -. It is applied in the normal way: [expression] OR [expression].
The OR in Excel is a function, not an operator. It is applied like this:
OR ([expression], [expression])
The Excel equivalent of the in-line if (or iif for short) statement above still requires that the conditions are set out in full:
- =IF(OR(A1 > 1, B1 > 1), "Yes", "No")
but this cannot be used in Access; use the IIF version listed above instead.
-Stewart