Can not group on fields selected with '*'

[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

 

[John W. Vinson]

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

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.

 

[Rick Brandt]

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?

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.