This isn’t always true outside of Access, so be careful when passing criteria expressions containing Null via ODBC and OLE DB connections. Add SQL’s Not operator to find values that aren’t Null.

Delivered Tuesdays and Thursdays Calculating Access fields with Null values Check out this article I found on TechRepublic.