Is there a limit to the number of OR criteria you can use??

K

KathrynM

Does anyone know if there is a limit to the number of OR
criteria that can be used in the QBE gird??

TIA
KathrynM
 
A

Allen Browne

Yes. Depends on your version. In Access 2003 you are limited to 100 AND/OR
phrases in a WHERE clause.

If you are hitting that limit, you may find the IN operator helpful, e.g.:
IN ("A", "B", "C", "D")
 

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

Is there any place I can get screen shots of Outlook Web Mail screens with notations? 0
Line callout arrow in a drawing canvas 1
Query multiple Criteria, pick one! 1
Page numbering with Merged Document and IF statements 1
How to count the numbers in a Word document? 0
Using a variable 'Top n' value from a form control 12
Microsoft Action Pack Subscription 0
Infopath file size exceeds the limit allowed and cannot be saved 0

Top