Access Query The Not criteria is excluding blanks

Copper Contributor

I have created a query that I want to include all records except those that are named Homeless. When I use  Not "Homeless" in the criteria to exclude those records, it also excludes records that have no value in the name.  What is the solution to this? 

2 Replies
Hello Stacie,

Would your query work if you change it to ... <> "Homeless" ?

Best regards,


Use this in the criteria:

Not "Homeless" Or Is Null