Is not null not working correctly

[KTJ_SBS]

can anyone tell me why in my query, when i add the criteria 'is not null' some blank cells still appear.

i have a table with emails in (text data type) in and whenever i run a query and add the criteria 'is not null' most of the records without an email disappear in the results but 1 or 2 still remain.

i cant for the life of me figure out why they are popping up. its as though access doesnt think they are blank?

any ideas?

 

[simongallop]

try the other option len([FieldName])>0. This will remove those cells that are null as well as those that are empty.