"Not " and "or" query 1

[sblanche]

I am trying to building a query. One field called "CounCrossSubject" has 20 available pick items. I want to show the records that have 17 of the items or is null. (I do not want to see records that have export, import or international*) In the query I can do

not "export" or is null - it works

however, when I add another item I want to exclude

Not "export" or not "International*" or is null

the query does not work. I still get "export". I don't want to add another line in my query for the 2 other "or"s (International* or Import) because I have other criteria to add which will probably require 6 other lines in my query grid. Any help would be greatly appreciated.

 

[GingerR]

you get "export" because it is NOT INTERNATIONAL. you should use AND instead of OR:

(not "export" and not "international") or is null

 

[tledwards]

When you start adding "not", "or" you need to group data with "()". Try

(Not "export" or not "International*" ) or is null

 

[sblanche]

To tek-tips and all those people who help us do our jobs-
Thank you very, very much--Mission accomplished.

 

[sblanche]

Opps--new problem with same query. It worked but when I enterred --
(not "export" and not "import" and not "*international*") or is null

Access change the 1 line into 2 and did--

<>"export" and <>"import and not like <>"*international*"

and then on the second line it added
Is Null

Any way to keep ACCESS from make 2 lines in the query?

Thanks,

 

[JonFer]

Different criteria lines in the query design is how Access represents your "OR" conditions. Everything on the same criteria line has "AND" between them. Why is the second line a problem?



John

http://www.interautomateconsulting.com

 

[sblanche]

I was concerned that I might run out of grid lines. I vaguely remember that on a previous query I could not add a 10th grid line to my query and was thus only allowed 9 lines. I might have to add more parameters to the query so the 3 additional lines concerned me. Since this AND and OR are in the same field instead of in different fields, I had hoped I could combine them. Thanks--

 

[JonFer]

There is a menu option to insert new criteria rows so it is okay.

John

http://www.interautomateconsulting.com