sorting numbers

[skate]

Hi, just wondering if anyone's got any good solutions for sorting numbers in which 03 (meaning year) when sorted descending is greater than 99.
As of now it sorts say from 99 down to 90 then switches to the year '03 to '00. How annoying.

 

[Pat Hartman]

Have you only just discovered one of the Y2K problems? You're three years late The solution is to sort the date field without formatting it. Of course, I'm making the assumption that your date is stored in a column defined as the date/time data type. If your date is stored as text, it's time to convert it.

 

[skate]

actually I am storing a number as text b/c it is actually not a date but a job number that begins w/ the last two digits of the year. Using a text is my only way to overcome 026013 not changing to 26013, but then I have the sorting issue.

 

[WayneRyan]

skate,

Given those ground rules, one option would be to convert to a
four-letter prefix.

Looping through a recordset would make the conversion
easy and it should not be too hard to mod your existing code
to live with it.

Wayne