Access Query The Not criteria is excluding blanks

[staholly]

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]

Hello Stacie,

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

Best regards,
Tieme

[#3]

Hi,

Use this in the criteria:

Not "Homeless" Or Is Null

Servus
Karl
http://AccessDevCon.com
https://www.donkarl.com