I have data that has numbers, numbers and letters and letters and numbers in a text field.
Looks like this
1,1a, 13a, 14a, 15o, PP23, PP23a, 2,44, AB3
Needs to sort like this:
1, 1a, 2, 13a, 14a, 15o, 44, AB3, PP23, PP23a
I used the val(fieldname) function in an Access 2010 query field and it sorts the numbers and numbers/letters OK, but it puts the letters/numbers first (because the value is 0) when I want them last.
Ideas
Looks like this
1,1a, 13a, 14a, 15o, PP23, PP23a, 2,44, AB3
Needs to sort like this:
1, 1a, 2, 13a, 14a, 15o, 44, AB3, PP23, PP23a
I used the val(fieldname) function in an Access 2010 query field and it sorts the numbers and numbers/letters OK, but it puts the letters/numbers first (because the value is 0) when I want them last.
Ideas