Blank Fields in NOT Null Query Criteria
Actually I was able to replace the ZLS records with text and then deleted the
text and now they are true NULLS.
"Steve Stad" wrote:
Jerry/Karl,
Thank you for replies. The blanks show up using Like "" in qry criteria.
Is there a way to replace these blanks (or ZLS) with something to make it
NULL.
"KARL DEWEY" wrote:
A Null is not the same as a 'blank' field. A Null is like a vacuum. If you
add something to a Null the results is Null. Adding something to a blank
gives you the something.
A 'blank' is also known as a zero-lenght string. If you are updating a text
field to remove all data there two ways - replace with a Null or two double
quotes. The two double quotes comprises a zero-lenght string.
Criteria to not show record in either case --
Is Not Null AND ""
--
Build a little, test a little.
"Steve Stad" wrote:
Why would a few blank fields show up in a query where I am using 'Is Not
Null' in the criteria. The rest of the Nulls are filtered out - but there
are 7 blank fields showing up. I went in to the table and hit delete in each
of the 7 fields but they still show up in the query results.
|