Re: Multiple Copies Query

Tech-Archive recommends: Fix windows errors by optimizing your registry

Adam

WHERE Len([yourField] & "") > 0

This problem arises when someone deletes data from a field (generally by
highlighting the cell in a table for query view and hitting the delete key,
or by deleting the data from a textbox on a form). When that happens, you
are left with a ZLS rather than a NULL.

Over time, I've gotten to where I generally use this method whenever I want
to check to see if the field is "empty".

HTH
Dale

--
Don''t forget to rate the post if it was helpful!

Email address is not valid.
Please reply to newsgroup only.


"Adam" wrote:

Hi Jeff

Thanks very much! I ran the query you suggested and it showed all the
records I DON'T want in my multiple copies query (i.e ones that I thought had
a null value but actually have a ZLS. So how do I ensure that this query only
has records where the entry in the "copies" column is >1?

Thanks again
Adam

"Jeff Boyce" wrote:

Adam

We humans have trouble seeing the difference between a Null and a
zero-length string (""). You could try running a query against that table
to see if there are any ZLS's in that field.

--
Regards

Jeff Boyce
www.InformationFutures.net

Microsoft Office/Access MVP
http://mvp.support.microsoft.com/

Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

"Adam" <Adam@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF2C22C7-221E-4CAF-9A28-698C8125548E@xxxxxxxxxxxxxxxx
I have a database set up for our company newsletter. I have a query that
allows me to see how many people receive multiple copies. The "copies"
column
in this query displays numbers like 2, 20, 35 etc. However when I opened
it
today there are records where the copies cell is blank. How can this be?
In
the design view the criteria says "Is not null." Perhaps it would be
better
if it said greater than 1. How would I go about doing this?


.

Relevant Pages

  • Re: Null Not Working in Query Search Criteria Variable
    ... Microsoft Office/Access MVP ... Jeff Boyce wrote: ... By the way I am doing multiple ... Joins in this query, not sure if that affects things or not. ...
    (microsoft.public.access.queries)
  • Re: Query not returning results for a text field
    ... I guess my next question is: Is this an accurate way to query for the ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... I have typed manually and copy/pasted the number into the criteria ...
    (microsoft.public.access.queries)
  • Re: Query not returning results for a text field
    ... I guess my next question is: Is this an accurate way to query for the ... "Jeff Boyce" wrote: ... Microsoft Office/Access MVP ... I have typed manually and copy/pasted the number into the criteria ...
    (microsoft.public.access.queries)
  • Re: Update top n records
    ... Microsoft Office/Access MVP ... to the query design window to see the code. ... "Jeff Boyce" wrote: ... All widgets have a number and are in numerical order in inventory. ...
    (microsoft.public.access.formscoding)
  • Re: new record
    ... Microsoft Office/Access MVP ... "Jeff Boyce" wrote: ... Create a query, include the date field, and add a selection criterion ...
    (microsoft.public.access.queries)