Hi, I have a simple query in access. Here is the SQL: SELECT Table1.[Field] FROM Table1 WHERE ((Not (Table1.[Field])="Y")); In the field column, there are only rows of Y and null fields. I want to select only the null fields, but when choosing the criteria not "Y", it does not return any rows. The datatype is Text and field size is 1. I have tried using a different field size and it still doesn't work. If I choose to select Null fields then the query works. Any idea why it doesn't work if I choose not Y in the criteria (therefore wanting to list null fields by default). Hope this makes sense. Thanks for your help.