You would use Is Null and Is Not Null in query expressions and SQL WHERE clauses. IsNull (), on the other hand, is a Visual Basic for Applications (VBA) function and would be used only in VBA modules.