Building iif expression

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Can someone please help me design an expression in expression builder
that included "equal or grater than".

The example is the query design has a field called "value", which is
the result of a formula (in the source query), Some of the values are
#Div/0, due to the formula.
I want the expression in my query to be :
=iif([value] "not equal or greater than" 0,"N/A",[value])
OR
=iif([value] = OR > 0, [value], "N/A"])

But these expressions are not allowed.
 
Your syntax is wrong. You are writing as if in English instead of Boolean
Algebra.
=iif([value] "not equal or greater than" 0,"N/A",[value])
Click to expand...
IIF( said:
=iif([value] = OR > 0, [value], "N/A"])
Click to expand...
Click to expand...
IIF(([Value] = 0 OR [Value] > 0, [Value], "N/A")
The you need something different.
IIF(([Value] = 0, "N/A", [YourOtherValue]/ [Value])
OR
IIF(([Value] = 0, 0, [YourOtherValue]/ [Value])


--
KARL DEWEY
Build a little - Test a little


Jack said:
Can someone please help me design an expression in expression builder
that included "equal or grater than".

The example is the query design has a field called "value", which is
the result of a formula (in the source query), Some of the values are
#Div/0, due to the formula.
I want the expression in my query to be :
=iif([value] "not equal or greater than" 0,"N/A",[value])
OR
=iif([value] = OR > 0, [value], "N/A"])

But these expressions are not allowed.
Click to expand...
 
Back
Top