Queries with Many "or" criteria

[Guest]

I am trying to create a query that will display all records except for ones
that I have listed in the criteria.
The format I am using is <>record1 or <> record2 <> record3... If I do this
for only one record the query works and returns all records except for the
one. When I have two or more records in the criteria, the query runs but
returns all records.
Why is this happening?

 

[Guest]

More information:
Access 2003 upgraded from Access '97

 

[Rick Brandt]

More information:
Access 2003 upgraded from Access '97

You need those ANDed instead of ORed. Record1 is returned because of the Or <>
Record2, Record2 comes back because of the <> Record1, etc..

 

[Lynn Trapp]

A little more information about your data and your query would be helpful,
but if you are using OR then, if a record matches any of the criteria it
will be returned. You may be looking for AND.

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Access Junkie List:
http://home.bendbroadband.com/conradsystems/accessjunkie.html

 

[Guest]

I have tried:
Not "record1" and Not "record2"....
<>"record1" and <>"record2"...
<>"record1" or <>"record2"...
Not "record1" or Not "record2"...

None of which work.
The records are int values and primary key in table.
Thanks for the feedback!

 

[Guest]

Try building a query that would pull all the records you do not want.

Second query include the first query joined on the field, all records from
table but only match in first query.

Criteria for field of first query Is Null.

 

[John Vinson]

I have tried:
Not "record1" and Not "record2"....
<>"record1" and <>"record2"...
<>"record1" or <>"record2"...
Not "record1" or Not "record2"...

None of which work.
The records are int values and primary key in table.
Thanks for the feedback!

Try

NOT IN(31, 45, 52, 88)


John W. Vinson[MVP]