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?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Dcount (multiple criteria) 3
Excel Need Countifs Formula Help 0
Date search query 0
Parameter Value error in a Subform 0
Autofill in Access 1
to Query or VB for pulling criteria from an unbound field 7
Query Parameter using multiple options 0
MS Access Date/Time Calculation After Midnight 1

Back
Top