Help with query - iff & greater than less then

Q

Qaspec

if field1 is greater than zero and less than 1 than 1 otherwise 0

Whats the right way to write that expression?
 
C

Conan Kelly

QASPEC,

NewCalculatedField: IIF([Field1] > 0 and [Field1] < 1, 1, 0)

HTH,

Conan
 
Top