SQL query – search for null field (Access 2K SR-1)

Topic

New Reply

How do we query for null field using SQL in Access? I want to search for records with blank (unfilled) value in a certain field. I try statements like

SELECT * FROM tblTable WHERE fldName LIKE ”
or
SELECT * FROM tblTable WHERE fldName LIKE ‘ ‘
or
SELECT * FROM tblTable WHERE fldName LIKE vbNullString
without success.

Can anyone help?

Reply | Quote

Replies

SELECT * FROM tblTable WHERE fieldname IS NULL

Reply | Quote

Thanks a lot for your help. It works. It puzzled why I couldn’t find the answer in common Access books available locally.

Reply | Quote