MS Access IsNull Function with Examples in SQL Query and VBA Code

Null is empty field that indicate the data is missing or unknown. IsNull function is the opposite of Is Not Null function. Normally, the attributes in field database are set to allow Null value except for Primary Key field. The syntax for IsNull function is: ( expression ) IsNull Parameter: Expression: the required SQL statement

source http://database.access-templates.com/ms-access-isnull-function-with-examples-in-sql-query-and-vba-code.html