Order query by date

[steve711]

I have searched for this but don't see anything that would trigger the help I need.

I have a query that needs to be in order by the month year. Example

April 2004 44.1
June 2004 133.1
May 2004 144.4
November 2004 231.1


Ok this is how it is ordering it now. Which is alphabetically. I need it chronologically by month / year.

Any help would be greatly appreciated.

 

[Jon K]

If the month years come from a date field, you can sort by Format([DateField],"yyyymm")

See query in the attached database.
.