Why do months get jumbled in reports?

[Guest]

When I make a query, I sort it by date by month. And so I have a query with
Nov 2005, Dec 2005, Jan 2006, Feb 2006, Mar 2006, Apr 2006, May 2006, June
2006

But in many cases, when I go to make a report, the dates get jumbled up.
(Apr 2006, Dec 2005, Mar 2006, Jun 2006, etc...)

How can I prevent this??

 

[JethroUK©]

are you sure they are defined as 'dates' and not 'text'?

 

[Steve Schapel]

Kevin,

I assume it is coming out in alphabetical order of the name of the
month, as one would expect when sorting on the data as you have defined
it. You will need to define an additional calculated field in the query
as well, purely for the purpose of sorting. Maybe it will be like this...
MonthSort: Format([YourDateField],"yyyymm")