ACC2000: Limit on ANDs in SQL Select Statement

There is an undocumented limit on the number of ANDs that you can use in an SQL Select statement. The limit is 99 ANDs in a WHERE clause and 99 ANDs in a HAVING clause.

Microsoft Access 2000 returns the following error messages when you exceed this limit:

-or-
The error can also occur if the query includes a Switch() function expression that contains more than 13 argument sets. The workaround is to create a user-defined function (UDF) incorporating a Select Case statement, and calling the UDF from the query.

For more information about SQL statements and clauses, click Microsoft Access Help on the Help menu, type work with sql in queries, forms, reports, macros, and modules in the Office Assistant or the Answer Wizard, and then click Search to view the topic.