On the basis of my query i have built a totals query as follows:
SELECT Sum(qryMargin.MarginInvoice) AS SumOfMarginInvoice, qryMargin.invoicedate
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 ?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!