And Or

[Ann]

Hi

I am looking for help on a criteria in a Query.
How many times levels of OR can I use?
It seems only 3???


Thanks in Advance

Ann

 

[Rick Brandt]

Hi

I am looking for help on a criteria in a Query.
How many times levels of OR can I use?
It seems only 3???

You can add more rows to the grid to allow more "ORs". Put the cursor on
an existing row and then on the menu use Insert - Rows.

There is an actual limit that you can find in the help file, but it is
substantially larger than anything you are likely to require.

 

[Brendan Reynolds \(MVP\)]

The help file (search for 'specifications') says that the number of ANDs
permitted in a WHERE or HAVING clause is 99. It doesn't explicitly mention
ORs but I'd be surprised if it doesn't mean either AND or OR.

What problem are you experiencing?