Report in calendar order

[khartoum]

I have created the query below:

SELECT Format([tblsales].[orderdate],'mmm') AS [Month], Sum(tblsales.VAT) AS SumOfVAT, Sum([quantity]*[tblproducts.productprice]+[vat]) AS total, Sum(tblsales.Discount) AS SumOfDiscount, Sum(tblsales.[Shipping&Delivery]) AS [SumOfShipping&Delivery]
FROM tblProducts INNER JOIN tblsales ON tblProducts.ProductCode=tblsales.ProductName
WHERE (((tblsales.OrderDate) Between [Forms]![frmreports]![datefrom] And [Forms]![frmreports]![dateto]))
GROUP BY Format([tblsales].[orderdate],'mmm'), tblsales.ProductName, tblsales.Quantity, tblProducts.ProductPrice, Format([tblsales].[orderdate],'mm')
ORDER BY format([tblsales].[orderdate],'mm');

The query extracts the monthly sales and dates it correctly in calendar order but when I have created the report from the query, the months are in alpha order. Have tried a few options in quewry design and report design but cannot get it to show in correct calendar order in report. Hoping this forum gives me the solution?


thanks

[June7]

Do you want to provide the project for analysis?

[khartoum]

Do you want to provide the project for analysis?

Yes, thanks as I think the combination of my query and report maybe the cause

It is two reports - Monthly Sales and Online Sales

[khartoum]

Hi June 7, have you had time to check my database in relation to the reports

[June7]

Only way I could get it to work was to base the grouping on the constructed month number field, Format([tblsales].[orderdate],'mm'). Don't even need field in a textbox on report. Can calculate that value in the query and reference that field name or in the report Group/Sort/Total settings with the Group By on expression.

[khartoum]

Hi June, thanks for that, so simple yet could not think how to do it
Regards KH