Re: Multiple Copies Query

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: Editing Access 2000 Program imported from Access97
    ... programming, but got Office Pro 2002 with my new computer in 2003. ... Have you tried "SELECT *" in a new query to see if you get your new field? ... Microsoft Office/Access MVP ... The Query takes every field,but "Discount" Naturally, that field is the ...
    (microsoft.public.access.conversion)
  • Re: Tables/Form
    ... THAT for your new sequence number in your new record. ... Use that value from the query in ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: join method
    ... Please post the SQL statement of your query. ... Microsoft Office/Access MVP ... if I join on CustomerID field I can get this: ... if I join on both CustomerID and EmployeeID I only will get the first ...
    (microsoft.public.access.queries)
  • Re: Tables/Form
    ... THAT for your new sequence number in your new record. ... Use that value from the query in ... Jeff Boyce ... Microsoft Office/Access MVP ...
    (microsoft.public.access.gettingstarted)
  • Re: Editing Access 2000 Program imported from Access97
    ... change in VBA at the CLOSE of a report to indicate those records have ... Have you tried "SELECT *" in a new query to see if you get your new ... Microsoft Office/Access MVP ... The Query takes every field,but "Discount" Naturally, that field is ...
    (microsoft.public.access.conversion)