ACC1: Additions to User's Guide Appendix A Specifications
ID: Q93691
|
The information in this article applies to:
-
Microsoft Access versions 1.0, 1.1
SUMMARY
This article includes additions to the Microsoft Access "User's Guide,"
Appendix A, "Microsoft Access Specifications." Note that some but not all
of this information may already be in the Microsoft Access "User's Guide."
MORE INFORMATION
Tables
------
Attribute Maximum
----------------------------------------------------------
Number of primary key fields and matching fields
when defining a relationship between tables 5
Queries
-------
Attribute Maximum
----------------------------------------------------------
Number of characters in a cell 255
Number of GROUP BY fields in a totals query 10
Number of fields allowed when query property
UniqueValuesOnly is selected (SELECT DISTINCT) 10
Number of ANDs in a WHERE clause (criteria) 40
Number of ANDs in a HAVING clause 40
Additional query words:
queries tables limits limitations spec
Keywords : kbusage GnlApp
Version : 1.0
Platform : WINDOWS
Issue type :