Access fails to group data! In this example Query, 

SELECT [Account Transactions].ID, [Account Transactions].Transaction_Amount, *
FROM [Account Transactions]
GROUP BY [Account Transactions].ID, [Account Transactions].Transaction_Amount;


This Idea is to Group Account Transaction.ID's and capture the Sum of tracaction_amount for all transaction of the same ID.

The code was generated by Access 2016 and when executed I get: 


  Can not group on Fields with '*'


The interesting thing is that I can generate a report with the very same grouping and it works perfectly.
The grouping may be the same, but you have an asterisk (shortcut for select all field, but the sequence is unkown what prevents grouping and aggregation) at the end of your selected fields that causes the error.

If you want to get the sum of Transaction_Amount per ID you just group by ID not by Transaction_Amount

SELECT
    Sum([Account Transactions].Transaction_Amount) As SumAmount
  , [Account Transactions].ID
FROM
    [Account Transactions]
GROUP BY
    [Account Transactions].ID