sort

[Amaresh_gante]

hello this my first message to all:
how can sort the id's:

i have Id's like:
TSR1
TSR2
TSR3
TSR33
TSR34
TSR45 in my database(ms-access)

when i display in form :

it sort like this:

TSR1
TSR2
TSR3
TSR31
TSR32
TSR33
TSR4
TSR41
TSR42

but i want to display this id like this:

TSR1
TSR2
TSR3
TSR4
TSR5
.
.
TSR20
TSR22
.
.
TSR30
TSR31
..
TSR231

please help me regarding this.

[r937]

ORDER BY 0+substring(id,4)