Is not null but some null records still showing up

B

babs

I have a text field and in the query I want to show only the records where
this field IS NOT NULL. Some records show up where this field Is NULL. I
played with it and put in IS null and get some records but the FEW that keep
showing up in the IS Not Null(which are actually Null). Not sure why the
records are not seen as NUll even though they are. Any ideas on what else I
may need to put on the criteria line??

Thanks,
Barb
 
D

Duane Hookom

We can't see your SQL or your data so it's a bit difficult to troubleshoot.
Do you have any records with a zero-length-string rather than Null? How do
you know the field contains a Null? What is your SQL view?
 
Top