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

[access2010]

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

 

[bob fitz]

Change the criteria for "Symbol_Stock_Y" from "Is Not Null" to "Is Null"

 

[access2010]

Change the criteria for "Symbol_Stock_Y" from "Is Not Null" to "Is Null"

Thank you, Bob Fitz

 

[Isaac]

@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?

 

[access2010]

Hello, Isaac.
We had tried your suggestion, but it did not work.

But, Bob Fitz's suggestion does work.

Crystal

 

[Isaac]

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!

 

[access2010]

Thanks for trying at assist us.

Crystal