new sorting method

  • Thread starter Thread starter Shawn
  • Start date Start date
S

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.
 
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)
 
Back
Top