Alphanumeric sorting of records

[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

 

[John Vinson]

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?

Could you explain what you mean by "an alphanumeric sort"?

 

[Tracy S.Weber]

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.

 

[John Vinson]

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.

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!

 

[Mike Painter]

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!