Access Query The Not criteria is excluding blanks

New 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,
Tieme

Hi,

Use this in the criteria:

Not "Homeless" Or Is Null

 

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