UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Sorting On Aa1 Trough To Aa10 Then Ab1 Through To Ab10, Access 2016    
 
   
wornout
post Aug 31 2017, 03:57 AM
Post#1



Posts: 972
Joined: 17-November 13
From: Orewa New Zealand


How do I sort this list
aa1
aa2
aa3
aa4 etc to aa13
ab1
ab2
ab3
ab4 etc to ab12
that goes through to aaf then goes on to
ba1
ba2 eyc
bb1
bb2
bb4 etc
my list they are all over the place so I need to sort on the first letter then second then the first number and then the 2nd number
Go to the top of the page
 
zocker
post Aug 31 2017, 06:50 AM
Post#2


Utterly Eccentric and Moderator
Posts: 4,055
Joined: 4-March 00
From: Bristol / Ipswich / Spain


Greetings! This thread HERE will help!

All the best!


Zocker

--------------------
I would like to remind members and visitors that UtterAccess is a NON SMOKING website. In that respect, it is the worlds first Thank you for not smoking.
Go to the top of the page
 
BruceM
post Aug 31 2017, 10:16 AM
Post#3


UtterAccess VIP
Posts: 7,022
Joined: 24-May 10
From: Downeast Maine


The Val function, referenced in the linked thread provided by Zocker, will not have the same effect here, although it can be part of the solution. Val stops at the first non-numeric character (I think it ignores spaces, though). In this case the values start with letters, so Val would return 0.

Are there always two letters at the beginning? If so, you could have calculated columns for the letter portion and the numeric portion:

LetterPart: Left(YourField,2)
NumberPart: Val(Mid(YourField,3))

Then sort on those columns.

There are options in other scenarios, but we can leave that aside for now.
Go to the top of the page
 


Custom Search
RSSSearch   Top   Lo-Fi    17th December 2017 - 12:18 PM