Excluding data from a query

Hello, you guys have helped me out on other ACCESS issues. I have a
query that excludes certain criteria using a Between and clause but I
need to exclude more cirteria from that query and I can't seem to get
it right. This database tracks advertising on buses by side (three).

Currently, I am querying each bus side seperatley: STREET, BACK,
QUEEN. On the STREET side we place KING ads, on the BACK side we
place TAILLIGHT ads, and on the CURB side we place QUEEN ads.
But....we cannot use the STREET side of 75 of those buses for the KING
ads because the bus is too small, we can only place QUEENS on that
side. I set up a query that pulls all STREET sides that are not
between 7000 and 7075 (# series of those buses), so it excludes those
buses and only counts the others that we are able to place KINGS on.
Problem is I have another set of numbers that I need to exclude in
addition to the 75 above. When I go into the criteria section of the
query and try to add to the not between clause the other information
still shows up. My criteria ends up looking like:

Bus Number: Not between "7000" and "7075" and "9100" and 9128"

but it only exludes the "7000" and "7075" leaving all the other buses
that fall within the 9100 to 9128 series.

How can I exclude all buses that fall withinn 7000 and 7075 as well as
9100 and 9128?

If you need more clarification on how I set things up, please let me
know. Any help is greatly appreciated.

Maria

.

Relevant Pages

  • Re: Excluding data from a query
    ... hmm, i've never tried to double up a Between...And criteria before, but you ... query that excludes certain criteria using a Between and clause but I ... need to exclude more cirteria from that query and I can't seem to get ... This database tracks advertising on buses by side. ...
    (microsoft.public.access.queries)
  • Re: Criteria & <>
    ... I'm trying to create a year-end check out report for my school. ... I'm having a problem creating the query for this new report. ... exclude certain records. ... I dropped to the "or" criteria line and added another title ID that I ...
    (microsoft.public.access.queries)
  • Re: Exclude records that meet criteria
    ... It is important to mention that if the field used in the subquery has Null ... the main query will never return anything. ... use a subquery on the second table in the criteria ... I need to exclude rather than include records from a table that meet ...
    (microsoft.public.access.modulesdaovba)
  • RE: Exclude
    ... to exclude results based upon date, put in the criteria of your query for ... how can I only exclcude previous weeks report weekly per completed/cancelled ...
    (microsoft.public.access.queries)
  • Re: how can I use a table as a list of records not to includ in a qry
    ... Tell us specifically what your criteria is. ... a query to include and exclude the criteria desired. ... > I have to get a table of records that have certain keywords and don't have ...
    (microsoft.public.access.queries)