How do I sort dates like Mar-05 in descending order?

[Mark Allsop]

I have a "LastUpdated" field in my Client database. Over
time the field is filled with dates; eg. Jun-03, Nov-03,
Feb-04, Sept-04, Feb-05, Mar-05 and so on. I want to sort
them in a query or SQL in decending chronological order.
ie. From now going back in time. How do I do this?

Thanks Mark Allsop (Devon, England)

 

[John Vinson]

I have a "LastUpdated" field in my Client database. Over
time the field is filled with dates; eg. Jun-03, Nov-03,
Feb-04, Sept-04, Feb-05, Mar-05 and so on. I want to sort
them in a query or SQL in decending chronological order.
ie. From now going back in time. How do I do this?

Thanks Mark Allsop (Devon, England)

Is this a Date/Time field or a Text field??? Date fields should have a
complete date (day month and year).

If this is a Date/Time field simply sort it descending.

If it's Text, put in a calculated field

CDate("01-" & [LastUpdated])

to put a day onto the field, and sort descending by this field.

John W. Vinson[MVP]