Alphanumeric Sorting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Text field that contains apartment numbers that vary from 1a-25l.

How can I sort so that the numeric floors are in sequence, ie 1A--9L, 10A,
11,A rather than the text sort I receive of 10A,...10L, 1A, 1B,...

Any ideas
 
John R said:
I have a Text field that contains apartment numbers that vary from 1a-25l.

How can I sort so that the numeric floors are in sequence, ie 1A--9L, 10A,
11,A rather than the text sort I receive of 10A,...10L, 1A, 1B,...

Any ideas
Click to expand...

Sort on the expression...

Val([YourField])
 
Thanks Ken:

It worked well. The key was adding the second sort field.

Thanks again

Ken Snell said:
Sort using two fields:

SortField1: Val([FieldName])
SortField2: [FieldName]
--

Ken Snell
<MS ACCESS MVP>

John R said:
I have a Text field that contains apartment numbers that vary from 1a-25l.

How can I sort so that the numeric floors are in sequence, ie 1A--9L, 10A,
11,A rather than the text sort I receive of 10A,...10L, 1A, 1B,...

Any ideas
Click to expand...
Click to expand...
 
Back
Top