Access Query The Not criteria is excluding blanks

%3CLINGO-SUB%20id%3D%22lingo-sub-2272418%22%20slang%3D%22en-US%22%3EAccess%20Query%20The%20Not%20criteria%20is%20excluding%20blanks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2272418%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20a%20query%20that%20I%20want%20to%20include%20all%20records%20except%20those%20that%20are%20named%20Homeless.%20When%20I%20use%26nbsp%3B%20Not%20%22Homeless%22%20in%20the%20criteria%20to%20exclude%20those%20records%2C%20it%20also%20excludes%20records%20that%20have%20no%20value%20in%20the%20name.%26nbsp%3B%20What%20is%20the%20solution%20to%20this%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2272418%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EAccess%20Not%20Issues%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
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