Maximum number of "or" statements in a select query

  • Thread starter Thread starter Ricardo
  • Start date Start date
R

Ricardo

Hi,

I have a select query with 8 raws of "or" criteria, but it
seems that I can't add any more. Is there a maximum number
of raws in a select query in Access 2000 ?

Thank you very much.
Ricardo
 
Eventually there is a maximum, but it is not a specific number, rather it is
measured by the complexity of the query. To your specific question though:
In the Query Builder, there are 8 rows by default, but you can add more by
going to the Insert > Rows on the Menu Bar.
 
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

Maximum size of Union Query? 3
Count Efficiency 2
default to 0 when query comes up with no results 8
Can you use query fields as function variables? 6
Serial number in Queries 2
Maximum number of nested IIf() statements in an expression 5
selecting nos from table 1
MsgBox in Update Queries 1

Back
Top