In SQL query criteria:

Fieldname IS NULL

in VBA code (you can use it in calculated expressions in SQL too):

IsNull([fieldname])

            John W. Vinson [MVP]