I am having the following query:
And then I get an error of aggregation. But how to achieve that?Code:SELECT DATA.Account_Number AS Account_Number, DATA.Service AS Service DATA.Area AS Area, SUM (DATA.Quantity) AS Quantity, SUM (DATA.Amount) AS Amount FROM DATA GROUP BY DATA.Account_Number, DATA.Service, DATA.Area;
My goal is to use the account numbers, service and same area and add the quantity and value of transactions, if I summarize.
Bookmarks