Group by month - can't get it to work !

[SpookiePower]

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 -

[Bob Fitz]

Untested, but you could try:

Select Month(DateSales) AS Mth, SUM(A) AS A, SUM(B) AS B
FROM Table
GROUP by Mth

[SpookiePower]

I think it's pretty close, but still not working.

I get this error - "You tried to execute a query that does not include the specified expression 'Month(DateSales)' as part of an aggregate function".

Could it be something with my date formatting ? My DateSales column has the date format 24-12-2013.

- Kim -

[Bob Fitz]

Have tested below. Works for me.

SELECT Month([DateSales]) AS Mth, Sum(A) AS AA, Sum(B) AS BB
FROM Table
GROUP BY Month([DateSales]);

[SpookiePower]

It works - Thanks

- Kim -