View Single Post
  #5  
Old May 28th, 2010, 01:48 PM posted to microsoft.public.access.queries
Steve Stad
external usenet poster
 
Posts: 89
Default 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.