Hi,

I am trying to find all records in a table where RETY_ID IsNull.  When I enter the code the Query either returns all records that have a value in RETY_ID or 0 records.  I cannot get the records with the field RETY_ID where the value is Null.

What is the Exact Syntax in the Query Criteria to display these records?  

Attached is:1 The Table design showing RETY_ID is Numeric. 2. The Query Design. 3: A section of the table showing both records with a value in RETY_ID and records with  Null Value and 4:Result from running the Query where the Criteria =IsNull(-1).  I have also tried  =IsNull(TRUE),IsNull(TRUE), ISNull(-1)

I have Googled this and all I can find is to put in IsNull(True) and this doesn't work!

Thx in advance

Ron dB