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")
 
Top