Access Sort Date

[Evelyn]

I have the short format for Date and when I sort on the report, dates are not ascending as requested. They are listed in this order:
December 2007
February 2008
March 2008
May 2008
November 2007
October 2007

Which is not in ascending (or descending) order. How do I fit this?

This is a simmple DB which consists of list of physicians and the number of patients per month. I have each physician as a group and the MonYr and the #pts per month.

Thank you.

 

[AnotherHiggins]

That is ascending order for an alphanumeric field.

What you have there is text, not actual dates.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[fneily]

First there are about 7 Access forums for Access questions. If you post Access questions there, you will get more answers.

What is the table type of your date field?
Databases are never simple if they're not normalize. Can you post your table structures - fieldnames, primary keys?