Can not group on fields selected with '*'
in [Queries]
|
From: Steve Stad on 24 Jan 2010 23:07 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
From: John W. Vinson on 25 Jan 2010 00:13 On Sun, 24 Jan 2010 20:07:02 -0800, Steve Stad <SteveStad(a)discussions.microsoft.com> wrote: >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. -- John W. Vinson [MVP]
From: Rick Brandt on 25 Jan 2010 07:15 Steve Stad wrote: > 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.
|
Pages: 1 Prev: Sorting misc text into new fields if data exists in record update Next: Nested views |