wlwebb
asked on
Access - Query with Sorting on 10 character Text field Alphanumeric
Hi all
Is there a way to sort a query on a text field that's alphanumeric where the field can be anywhere from 1 to 10 characters and Alpha can be in any position and Number can be in any position?
Obvious to you experts just sorting gives me
1
10
100
11
12
2
21
3
etc...
Is there a way to sort a query on a text field that's alphanumeric where the field can be anywhere from 1 to 10 characters and Alpha can be in any position and Number can be in any position?
Obvious to you experts just sorting gives me
1
10
100
11
12
2
21
3
etc...
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks!
/gustav
/gustav
ASKER