'Item' not part of aggregate function or grouping.
Error 3122
You tried to execute a query that doesn't include the specified expression as part of an aggregate function or grouping.
Possible cause:
You didn't enter an aggregate function in the TRANSFORM
Statement (SQL).
See Also
GROUP BY Clause (SQL)
Using SQL (Structured Query Language)