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

[Kenneth Jones]

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.

[MMcCarthy]

Can you post the query you are trying to run? Normally using the NZ() function on the field you are querying works.

NZ([MyFieldName],"")

Then set the criteria to "" to get the results.