The following table gives the maximum size for various attributes of a query.
Attribute | Maximum |
Number of tables in a query | 32 |
Number of fields in a recordset | 255 |
Number of fields in an ORDER BY clause | 10 |
Number of levels of nested queries | 50 |
Number of characters in a parameter name | 255 |
Number of ANDs in an expression | 40 |
Number of characters in an SQL statement | Approximately 64,000 |