ACC: "Can't group on fields selected with '*'" Error MessageLast reviewed: May 28, 1997Article ID: Q103189 |
The information in this article applies to:
SYMPTOMSModerate: Requires basic macro, coding, and interoperability skills When you set the following query property, you may receive the error message "Can't group on fields selected with '*'":
Version Property Value ----------------------------------------------------------------- Microsoft Access 2.0 and 7.0 Output All Fields Yes Microsoft Access 1.x Restrict Available Fields No CAUSEThis error message occurs when you are attempting to use aggregate (totals) functions without setting the Output All Fields query property to No for version 2.0 and 7.0, or without selecting the Restrict Available Fields property for version 1.x.
RESOLUTIONThe following procedure shows how to correctly set this property for your query with aggregate functions:
MORE INFORMATION
Steps to Reproduce Behavior
REFERENCESFor more information about setting the OutputAllFields property, search for "Setting Query Properties," and then "Set properties for a query, its fields, or its field lists" using the Answer Wizard from the Microsoft Access for Windows 95 Help menu. For more information about setting the OutputAllFields property, search for "Setting Query Properties" using the Microsoft Access 2.0 Help menu. |
Keywords : kbusage QryTotal
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |