Article ID: 103189 - Last Review: January 18, 2007 - Revision: 2.1

ACC: "Can't Group on Fields Selected with '*'" Error Message

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
This article was previously published under Q103189
Moderate: Requires basic macro, coding, and interoperability skills.

On This Page

Expand all | Collapse all

SYMPTOMS

When you set the Output All Fields query property to Yes, you may receive the following error message:
Can't group on fields selected with '*'.
Back to the top

CAUSE

This error message occurs when you are attempting to use aggregate (totals) functions without setting the Output All Fields query property to No.
Back to the top

RESOLUTION

The following procedure shows you how to set this property for your query with aggregate functions:
  1. Open the query in Design view.
  2. Make sure that the Properties command on the View menu is checked, so that the property sheet is being displayed. Click anywhere in the Query window outside of the query grid and the field lists. Set the Output All Fields property to No.
Back to the top

MORE INFORMATION

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb (or NWIND.MDB in version 2.0).
  2. Run the Order Subtotals query, which uses the aggregate function Sum(), to confirm that it works correctly.
  3. View the Order Subtotals query in Design view.
  4. Set the Output All Fields property to Yes.
  5. Run the query. Note that you receive the error in the symptoms section of this article.
Back to the top

REFERENCES

For 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 Office Assistant or the Answer Wizard in Microsoft Access on-line help.

For more information about setting the OutputAllFields property, search for "Setting Query Properties" using the Microsoft Access 2.0 Help menu.
Back to the top
APPLIES TO
  • Microsoft Access 2.0 Standard Edition
  • Microsoft Access 95 Standard Edition
  • Microsoft Access 97 Standard Edition
Back to the top
Keywords: 
kbprb kbusage KB103189
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top
 

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations