Queries have a number of specifications and limitations that you should be aware of. Fortunately, you will generally not find them too restricting. They are listed in Table 4.3:
Item | Limitation |
|---|---|
Number of enforced relationships | 32 per table minus the number of indexes that are on the table for fields or combinations of fields that are not involved in relationships |
Number of tables in a query | 32 |
Number of fields in a recordset | 255 |
Recordset size | 1 gigabyte |
Sort limit | 255 characters in one or more fields |
Number of levels of nested queries | 50 |
Number of characters in a cell of the query design grid | 1024 |
Number of characters for a parameter in a parameter query | 255 |
Number of ANDs in a WHERE or HAVING clause | AG99 |
Approximately 64,000 |