A months query

[Peljo]

On the basis of my query i have built a totals query as follows:
SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate
FROM qryMargin


GROUP BY qryMargin.invoicedate;

I want to break down the sum so obtained into months on the basis of the invoicedateand also to arrange them to be not in
alphabetical order but following the order of the months, e.g. january,february,march etc
Can you help me ?

[jya]

Just add a Format around your invoice date in your Select and a Month in your Group By.

SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, Format(qryMargin.invoicedate,"mmm") 
FROM qryMargin 
GROUP BY Month(qryMargin.invoicedate);