Alphanumeric sorting of records

  • Thread starter Thread starter Tracy S. Weber
  • Start date Start date
T

Tracy S. Weber

I've been trying to find a way to sort an access database
we have by alphanumeric order vice the normal simple sort
option afforded by Access. Does anyone have any info or
ideas what I can do to manage this?

Thanks,
Tracy
 
I've been trying to find a way to sort an access database
we have by alphanumeric order vice the normal simple sort
option afforded by Access. Does anyone have any info or
ideas what I can do to manage this?
Click to expand...

Could you explain what you mean by "an alphanumeric sort"?
 
I need to sort cable numbers that are composed of numbers
and letters such as 1fg121, 13ms019, and so forth.
Basically what I get now is 1fg121,10fg234,2fg160 instead
of 1fg121,2fg160,10fg234.
 
I need to sort cable numbers that are composed of numbers
and letters such as 1fg121, 13ms019, and so forth.
Basically what I get now is 1fg121,10fg234,2fg160 instead
of 1fg121,2fg160,10fg234.
Click to expand...

Try putting a calculated field in the Query, *before* the cable
number, by typing

SortCable: Val([cablenumber])

Sort by both this field (which will contain 1 for 1fg121, 10 for
10fg234 and so on) and the cable number, so that 1fg21 and 1xz83 sort
correctly.

If you have to sort 1fg21 before 1fg203, it's going to get a lot more
complicated!
 
It should be noted that the column *is* being sorted alphanumerically.

Try putting a calculated field in the Query, *before* the cable
number, by typing

SortCable: Val([cablenumber])

Sort by both this field (which will contain 1 for 1fg121, 10 for
10fg234 and so on) and the cable number, so that 1fg21 and 1xz83 sort
correctly.

If you have to sort 1fg21 before 1fg203, it's going to get a lot more
complicated!
Click to expand...
 
Back
Top