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.

 

[Pat Hartman]

The data is sorting as you told it to sort. Once you convert a date to a string, it behaves like a string. To solve the problem, include the original, unformated, date field in the query and use that in the order by clause.