Design a query to show only empty field TEXT fields in table

[mkdrep]

I have searched the Query forum for quite awhile and can't seem to find an answer to this question, even though it seems pretty easy, I can't figure a way to do it.:banghead:

I am just querying a single table, no relationship involved with another table. As you can see form the attached jpeg, the ZIP field in some cases is empty. I would run a search using Is NULL but the field is NOT numerical. It's a long story but I had to make this field a TEXT field.

Basically, what statement do I have to insert in the criteria field to just pull up the EMPTY ZIP fields? Thanks.....Mark

(I have a feeling that this is so simply I will have egg on my face!) lol

 

[pbaldy]

A text field can be null, but try

WHERE Nz(Zip, "") = ""

 

[mkdrep]

A text field can be null, but try

WHERE Nz(Zip, "") = ""

Thanks, Paul! Actually, I took a break and it finally came to me....all I had to do was put =" " in the criteria field and I got the results I wanted. I knew it had a simple answer! lol