Building iif expression

[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.

 

[Guest]

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])

=iif([value] = OR > 0, [value], "N/A"])

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

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.

 

[Jason Lepack]

iif([value] >= 0, "N/A", [value])