Can't group on Memo or Long Binary (Item).
The GROUP BY Clause (SQL) of an SQL statement can't include Memo or Long Binary fields.
Can't have action query 'Item' as an input.
You can't use the name of an action query Instead, use the name of a select query. To run an action query, use the Execute method. here.