Limitation on ORs in Query

  • Thread starter Thread starter Barbara Shapiro
  • Start date Start date
B

Barbara Shapiro

Using Access 2007, it seems to limit me to 9 levels in the criteria area of
my query.

In Access 2003n I was able to create the same type of query with 32 levels
and more available.

Is there a setting/option that can be changed somewhere to allow more than 9??
 
Never Mind, I figured it out. You have to use "Insert Rows", which you can
add to the ribbon.
 
With that many OR's I would use a table like this --
SELECT Sack, Reed, Etc
FROM YourTable, My_OR_List
WHERE [YourTable].[Sack] = My_OR_List.MyField;

or like this --
SELECT Sack, Reed, Etc
FROM YourTable INNER JOIN My_OR_List ON [YourTable].[Sack] =
My_OR_List.MyField;
 
Using Access 2007, it seems to limit me to 9 levels in the criteria area of
my query.

In Access 2003n I was able to create the same type of query with 32 levels
and more available.

Is there a setting/option that can be changed somewhere to allow more than 9??
Click to expand...

In addition to Karl's excellent suggestion of a linked table, you can also use
the syntax

IN ("a", "wx", "bq", "lg")

or

IN (3,8,11,21,46)

as a criterion if there are multiple criteria.
 
Back
Top