And Or

  • Thread starter Thread starter Ann
  • Start date Start date
A

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
 
Ann said:
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???
Click to expand...

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.
 
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?
 
Back
Top