Hi Jos,

>just ORDER BY MyTable.HiredDate would order in correct chronological order
>Year-Month-Day. Or have I misunderstood the question?

Not quite what I need. Say you want to send a Hired Date Anniversary card to each person who was hired during the Month of July no matter what year, and you want them printed out for your secretary in Month-Day order.

>Another option could be:

>SELECT Fld1, Fld2, FldX, MONTH( HiredDate ) AS nMonth, DAY( HiredDate ) AS
>nDAY FROM MyTable ORDER BY nMonth, nDay<
>

Yep... that did the trick. Thanks a million.

Mel Cummings