Can't group on fields selected with '*' (Item).
Error 3120
You tried to execute a select that groups or totals fields selected with an asterisk ( * ). For example, this error occurs if you use the following SQL statement:
SELECT Orders.* FROM Orders GROUP BY [Ship Via];