Null/Empty Field, cannot get to return

[wolves]

I have a field that I though was Null or empty, but I do not seem to be able to get a return from my table.
So far I tried:



Len(Trim(Nz(myfield,"")&"")) > 0
Nz(Table1.Field1,'')='';

NZ([fieldname],0)


I assume the field has to be either NULL or empty, but why do I not get any returns from my query?

 

[PHV]

And this ?
Trim([myfield] & "") = ""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wolves]

OK, the NZ([fieldname],0) was working, I did not realize it because there was too much data and all my null fields are at the bottom.

So my null fields display as '0', how do I change the query so that only my null or '0' fields are returned in the query, rather then everything, plus my null fields?

 

[PHV]

WHERE NZ([fieldname],0)=0

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wolves]

Yes, just found that. Thanks again for the help.