Is Not Null

Afternoon,

I know this will be a simple If THen statement, but I am having issues. I am in the design view of a query is Access.

I simply want to say if that is the below cell (Freight Terms) is NOT BLANK (i.e, there is data in the cell), then to give me a 1, if not, give me a 2.

I am getting an error that states "undefined function"IsNotNull" in expression", and I am trying to understand why. Unlike Excel, the IsBlank() function does not appear to work...Any assistance would be appreciated

Expr2: IIf(IsNotNull([Freight Terms]),"1","2")

Thank You,

Upon researching Access functions, I have not come across Is Not Null...However, the functions IsNumeric() and IsDate() appear to solve this issue in Access.

If that offers any value to anyone.