Filtering out null or empty fields

[armstrong722]

I have built a query that pulls out certain people with their email addresses. I get some in there that do not have email addresses(and won't) I am trying to get them out of the list but to no avail. I use fieldname <> &quot;&quot; or fieldname <> null and there is no difference between that and not putting in those statements is there anything else that I could be doing wrong???

 

[RobertT687]

The email address field may contain a single or multiple space characters. Try testing for Trim(fieldname)<>&quot;&quot;.

 

[mscraig]

Try - Is Not Null - instead of <> null. Sometimes Access doesn't interpret <> null correctly. Also continue to use <> &quot; &quot; in your criteria. Sometimes - Not Like &quot; &quot; - works.