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.

 

[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