Pepraphs my question is not appropriate...
Is possible to use the "select * ..." and group by field1 and field2?
group by with star *
-
- Administrator
- Posts: 78512
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: group by with star *
In a Totals query, each field that you don't group on must use an aggregate function such as Sum, Count, Min etc. So you can't use *.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4357
- Joined: 26 Apr 2010, 17:36
Re: group by with star *
hummmmmmmmmm...HansV wrote:No, unless Field1 and Field2 are the only fields in the table.
In a Totals query, each field that you don't group on must use an aggregate function such as Sum, Count, Min etc. So you can't use *.
But tks in other case!