Can not group on fields selected with '*'

  • Thread starter Thread starter Steve Stad
  • Start date Start date
S

Steve Stad

Trying to run an aggregate/totals query to group on a particular field but
getting message...."Can not group on fields selected with '*' . And when I
pick one field in qry all of the fields in the table show up in the View. Is
it due to the relations?

Thanks
 
Trying to run an aggregate/totals query to group on a particular field but
getting message...."Can not group on fields selected with '*' . And when I
pick one field in qry all of the fields in the table show up in the View. Is
it due to the relations?

Thanks
Click to expand...

No, it's due to your selecting the * "pseudofield" in the query design window.

If you open the query in SQL view you will see something like

SELECT *, <other fields> FROM...

Remove the *, from the SQL and you should be OK.
 
Steve said:
Trying to run an aggregate/totals query to group on a particular field but
getting message...."Can not group on fields selected with '*' . And when
I
pick one field in qry all of the fields in the table show up in the View.
Is it due to the relations?
Click to expand...

Open your query in design view and then open the property sheet. You should
find a property named "Output All Fields". Set that to "No".

That is the default setting so you must have done something to change it.
 
Back
Top