Alphanumeric Sorting

[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

 

[Ken Snell [MVP]]

Sort using two fields:

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

 

[Rick Brandt]

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

Sort on the expression...

Val([YourField])

 

[Guest]

Thanks Ken:

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

Thanks again

Sort using two fields:

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

Ken Snell
<MS ACCESS MVP>

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