I have a table with 3 columns, A and B and DateSales
I want to SUM A and B and group the result in months like this -
Month A B
Jan 100 300
Feb 50 90
... ... ...
My SQL looks like this -
Select DateSales AS Month, SUM(A) AS A, SUM(B) AS B
FROM Table
GROUP by DateSales.Month
I have tried many different settings with the GROUP BY, but I get an error each time in that line.
Someone who can help ?
- Kim -