Is Not Null

[Rich1968]

Hey There!

I am trying to produce a list of e mail addresses from a query. I do not want any blank fields to show up. So I put "Is Not Null" (without the quotes) in the critera section of my query. I still get null values.

Any Suggestions?

Thanks

Rich1968

 

[Martins]

Hi Rich,

Is the email field's data type text? Try <> "" in the criteria section.

Regards,

Martins

 

[Rx_]

Did you check for empty strings? Possibly a single space
In the query - add a new field and put
MyLen: IsNull([FieldName])
where field name is the field you are checking
If it is < 0 (-1) it might not be null.

Martins beat me to the post LOL - that is a good solution.