[AccessD] Text Field Sort Order 1.1 - 10 - 2 into 1.1 - 2 - 10

Borge Steen Hansen pcs at azizaz.com
Mon Jun 16 08:18:44 CDT 2003


We have a text field with data like this when sorted ascending:

1
1.1
1.2
10
10.1
11
11.1
11.2
2
2.1
2.2
3
3.1.
3.1.1
3.1.2
3.1.3
4
etc etc.

Any one got ideas for how to sort the field like this:
1
1.1
1.2
2
2.1
2.2
3
3.1.
3.1.1
3.1.2
3.1.3
4
....

10
10.1
11
11.1
11.2

?????

Regards
Borge Hansen



More information about the AccessD mailing list