Date order in a Query

[Houlkers]

I have started a table to manage expenditure with dates payments and headings. Set up a query to summarise the monthly amounts by each heading. The Query is sorting the date in date in alpha order not date order so I get February before March etc. How do I get it to show chronological order?

 

[jdraw]

How are you storing your Dates? Is Date a date/time field or have you formatted them to be strings?

 

[Houlkers]

I have stored them in the original table as Date and Time fields. Bit of a novice so do not know what formatting with strings is.