IF Then with Access

C

carl

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

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
 
Top