Q Qaspec Mar 13, 2008 #1 if field1 is greater than zero and less than 1 than 1 otherwise 0 Whats the right way to write that expression?
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 Mar 13, 2008 #2 QASPEC, NewCalculatedField: IIF([Field1] > 0 and [Field1] < 1, 1, 0) HTH, Conan
