Query Specifications

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