Can't group on fields selected with '*'.
You tried to execute a select that groups or totals fields selected with an asterisk ( * ).
You created an SQL statement that includes an aggregate function or GROUP BY Clause (SQL) that refers to a field you selected with an asterisk. This error occurs, for example, if you enter the following SQL statement:
SELECT * FROM Orders GROUP BY [Ship Via];