How can you sort access databases in an alfa-numerical order.

In VB i get it like this:
C1
C10
C11
C2
C3

But I wouldt like it in this order:
C1
C2
C3
C10
C11

Can anyone PLEASE help me.

Carl Hansson

what you get _IS_ the alpha-numerical order. In your example you have
strings, not numeric values. They are compared from left to right.
If you want them to be sorted as desired, there are two possibilities:

Store the data as C01, C02, C03, C10, C11 (remember they are still
strings, and C100 will be sorted right after C10).
Or split the string into a textfield and a numeric field, and then sort
like this "... ORDER BY TextField, NumericField"

Hope it helps

Thomas

*****
If you are well, don't worry ... it will pass over.
*****