G Guest May 31, 2006 #1 Can a new Field be created that would be 1 if FieldA is less than zero, 0 if greater than or equal to zero ? Thank you in advance.
Can a new Field be created that would be 1 if FieldA is less than zero, 0 if greater than or equal to zero ? Thank you in advance.
T Tom Lake May 31, 2006 #2 carl said: Can a new Field be created that would be 1 if FieldA is less than zero, 0 if greater than or equal to zero ? Click to expand... Yes. IIf([FieldA] < 0, 1, 0) Tom Lake
carl said: Can a new Field be created that would be 1 if FieldA is less than zero, 0 if greater than or equal to zero ? Click to expand... Yes. IIf([FieldA] < 0, 1, 0) Tom Lake
