Sorting on the Month of a date of birth

[MrsNic]

I have a query in which I have used DatePart to separate the day and the month from a person's date of birth.

I am trying to create a report that will sort the birthdays into Months. I have tried using Date of birth - month but it still sorts into the different years e.g. jan 1990 Feb 1990 . . . then Jan 1991 etc.

I have also tried to get it to sort on the datepart month, this works but only shows 1, 2 or 3 etc. I have tried changing the formatting for this but with no success.

Any ideas please.

 

[GingerR]

What's your query?

How about

Format([YourDate],"mmm")

?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[SkipVought]

Or...

Select Format([Birthdate],"mm-dd")...
from...
...
Order by 1

will sort better than "mmm", and will include the day as well if so desired.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[dhookom]

The sort order in the query generally doesn't make any difference. Set the sorting and grouping in the report and use an expression like:
=Month([YourDateField])

Duane MS Access MVP
Now help me support United Cerebral Palsy