Pulling A Field that is Null

[VBAmateur]

I am trying to pull a set of records in a Access DB where all fields of column X are NULL. I am using an ADO and trying to use the following SQL to pull the recordset but it does not like this, Any suggestions for this statement please:

strQuery = "SELECT * FROM REPOINVENTORY WHERE DateTtlRcvD =" & vbnull

[Aaron Young]

Try:

strQuery = "SELECT * FROM REPOINVENTORY WHERE DateTtlRcvD = NULL"

[VBAmateur]

THAT DIDN'T WORK. THANKS THOUGH

[Mark Sreeves]

strQuery = "SELECT * FROM REPOINVENTORY WHERE DateTtlRcvD Is Null"