Microsoft Access Query..?

Question

I'm trying to create a query in Access and want it to include all blank fields. I thought I typed "null" to show the blanks under the criteria in Design view but this seems to be wrong. Does anyone know what needs to be typed in the criteria?

Answer 1

If you want to see only the records with blank or empty fields then use

Is Null or ""

If you want to include the blank or empty fields with the other records, then leave the criteria out.

Answer 2

Try ""

(A zero-length string)

Answer 3

A common misconception. A field that is NULL is not the same as one that is empty or zero. NULL means 'does not exist'. If the field was defined as nullable, then you may be able to retrieve a default replacement value for any field that is NULL (check your DBMS documentation for the COALESCE command as one possibility).