jwcolby
jwcolby at colbyconsulting.com
Tue Jul 24 12:13:16 CDT 2007
You could reasonably quickly set up a test to find out by building a dynamic query, a string such as select PKID from tblX where (PKID=1 or PKID=2 or...). Add 10 (or 100) at a time and see how far you get. John W. Colby Colby Consulting www.ColbyConsulting.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Dan Waters Sent: Tuesday, July 24, 2007 1:02 PM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Number of 'OR's in queries - what's the limit? In Access 97, there was a limit of 40 OR words in a query. There is a limit in Access 2003, it's >250, but I don't know what it actually is. Does anyone know? Thanks! Dan -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com