Sort dates chronologically instead of alphabetically (using a query)?

[DanicaDear]

I work for a testing lab. I enter into a table how many units I test, how many pass, and how many fail each week. I made a query which sums all of the units by the month (so in October 2009 there would be 4 weeks=4 entires to sum up). I want to display them chronologically . When I first run the query, they appear in chronological order. However, when I enter design mode, they change to alphabetical order and I can't get them coverted back. I'm a very beginner...so I need something simple. Any ideas?

[DanicaDear]

DATE_ENTERED By Month: Format$([HOTSTICK_FAILUR E].[DATE_ENTERED],'mmmm yyyy')

one solution I just came up with is to change my field to this:

DATE_ENTERED By Month: Format$([HOTSTICK_FAILUR E].[DATE_ENTERED],'yyyy-mm')

This yields the results I desire...but it sure was nice to see the month written out. Now what?

[NeoPa]

Have one field which displays the results you require. Have another field which is not displayed, but which you sort by. This should be the unformatted date.