By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,786 Members | 2,241 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,786 IT Pros & Developers. It's quick & easy.

How to query a NULL value in a Text formatted Table Column?

P: n/a
How Can You Successfully Query a NULL value in a Text formatted Table Column? This is a known problem per internet articles I have read and I cannot get the query to execute properly.
Sep 30 '10 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 10K+
P: 14,534
Can you post the query you are trying to run? Normally using the NZ() function on the field you are querying works.

Expand|Select|Wrap|Line Numbers
  1. NZ([MyFieldName],"")
Then set the criteria to "" to get the results.
Sep 30 '10 #2

Post your reply

Sign in to post your reply or Sign up for a free account.