Prev: Access 2K2: making numbers up in a query sum
Next: A Great Big Thank You!
From: KARL DEWEY on 28 May 2010 10:19
Deleting text makes them zero lenght strings, not nulls.
Use an update query to either have all nulls or zero lenght strings.

Update To: Null
Criteria: ""

Or --
Update To: ""
Criteria: Is Null


--
Build a little, test a little.


"Steve Stad" wrote:

> 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.
First  |  Prev  | 
Pages: 1 2
Prev: Access 2K2: making numbers up in a query sum
Next: A Great Big Thank You!