G
Guest
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
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