That works! Sort by month and day using the first key option then by year
using the A/Z button. Cool, thanks!

"CyberTaz" wrote:

BTW- Year doen't have to be to the left... too much Access lately.

Regads |:)

"CyberTaz" wrote:

Hi Greg-

No need to convert... Click in that column, then go to DataSort & click the
Options button. Open the 'First key sort order' list and choose
appropriately, the click OK in each box.

HTH |:)

"Greg" wrote:

I have a column with months as text (April, etc.). Trying to sort them in
order, is there a way to convert them to dates or numbers in order to sort