new sorting method

[Shawn]

i would like to be able to sort a column in a table
that has nothing but 5 numbers such as 14201, 12303,
13604, etc. the format is all the same. xxx02 or 03 or 04
i would like to have this column sort by the last 2
digits first. how can i do this.

 

[Douglas J. Steele]

In your query, create a computed field LastTwoDigits: [MyNumber] -
([MyNumber] \ 100) * 100 and sort on it. (Note the direction of the \: it's
not the normal / used for division)