Query if any of the 5 fields are empty (1 Viewer)

access2010

Registered User.
Local time
Today, 13:58
Joined
Dec 26, 2009
Messages
1,019
Could I please receive a suggestion on how to find ONLY THE RECORDS, THAT DO NOT have data in any of the 5 chosen fields as my Access 2003 query is not working?

Thank you.
Crystal
 

Attachments

  • Query_Any_Field_Blank=21=088.mdb
    324 KB · Views: 161

bob fitz

AWF VIP
Local time
Today, 20:58
Joined
May 23, 2011
Messages
4,717
Change the criteria for "Symbol_Stock_Y" from "Is Not Null" to "Is Null"
 

Isaac

Lifelong Learner
Local time
Today, 13:58
Joined
Mar 14, 2017
Messages
8,738
@access2010

The way I read your original post, you only want to retrieve records that do not have data in ANY of the five columns. Thus, they should ALL be null--not just one of them.

Wouldn't the proper query to achieve that result look more like this?

1617043820419.png
 

access2010

Registered User.
Local time
Today, 13:58
Joined
Dec 26, 2009
Messages
1,019
Hello, Isaac.
We had tried your suggestion, but it did not work.

But, Bob Fitz's suggestion does work.

Crystal
 

Isaac

Lifelong Learner
Local time
Today, 13:58
Joined
Mar 14, 2017
Messages
8,738
Well, I agree with his suggestion in that if you want to find ones that are Null, you'd obviously have to change Is Not Null to "Is Null".

I'm just trying to reconcile all of your query's OR statements (which is what those numerous vertical rows of criteria equate to), vs. your original post, and was unable to.

If you're happy I'm happy! :) :)
 

Users who are viewing this thread

Top Bottom