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?
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?