Can't have aggregate function in GROUP BY clause (Item).

Error 3098

You can't use an aggregate function in the GROUP BY Clause (SQL)61THXA8 of an SQL statement29F05E5.

See Also

SQL Aggregate FunctionsM7QTSY