Sorting issue

[Erictsang]

Dear all



I have an issue in Sorting

i use the Pair cocolumno sort the sequence and to make sure that Pari no is
1.1 , 1.2 , 2.1, 2.2
However, the result was like follow, how can i solve it ??

PAIR	PAIRNO
G00011.1	1.1
G00011.2	1.2
G000110.1	10.1
G000110.2	10.2
G000111.1	11.1
G000111.2	11.2
G000112.1	12.1
G000112.2	12.2
G000113.1	13.1
G000113.2	13.2
G000114.1	14.1
G000114.2	14.2
G000115.1	15.1
G000115.2	15.2
G000116.1	16.1
G000116.2	16.2
G000117.1	17.1
G000117.2	17.2
G000118.1	18.1
G000118.2	18.2
G000119.1	19.1
G000119.2	19.2
G00012.1	2.1
G00012.2	2.2

[JoeM]

That is because your field you are sorting on is string (text). Change it to number and it should sort the way you want.

[Bulzie]

Why did you ask this same question when you said what we offered worked or that it was solved in the other thread?

https://www.accessforums.net/showthread.php?t=67440