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

In your querydef use the Val() function.
Sort Asc both on Val(Field) then the field.
Your query will sort by the value of the field to the second decimal point.
Then it will sort the rest.
HTH
Jim

-----Original Message-----
From: Borge Steen Hansen [mailto:pcs at azizaz.com]
Sent: Monday, June 16, 2003 8:19 AM
To: accessd at databaseadvisors.com
Subject: [AccessD] Text Field Sort Order 1.1 - 10 - 2 into 1.1 - 2 - 10


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

_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com