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