By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,828 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

ascii sort

P: n/a
Is there a way to do an ascii sort with ms-access ?
exemple:
unsorted list= A B a C
default sorted list=A a B C
what I would like to have= A B C a

Thanks in advance for your help
Pascal
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Pascal,

You can use the Asc function. The Asc function only returns the Ascii value of
the first character of a string. So if you want to sort on the first three
characters of a set of string values in a field, create a query. In the first
column put:
=Asc([TheFieldName])
In the second column put:
=Asc(Mid([TheFieldName],2,1))
In the third column put:
=Asc(Mid([TheFieldName],3,1))

Set the sort for all columns Ascending
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Pascal Perrot" <pe***********@emc.com> wrote in message
news:bu**********@public.stna.aviation-civile.gouv.fr...
Is there a way to do an ascii sort with ms-access ?
exemple:
unsorted list= A B a C
default sorted list=A a B C
what I would like to have= A B C a

Thanks in advance for your help
Pascal

Nov 12 '05 #2

P: n/a
Thanks a lot for your help.

"PC Datasheet" <sp**@nospam.spam> a écrit dans le message de
news:tY****************@newsread3.news.atl.earthli nk.net...
Pascal,

You can use the Asc function. The Asc function only returns the Ascii value of the first character of a string. So if you want to sort on the first three
characters of a set of string values in a field, create a query. In the first column put:
=Asc([TheFieldName])
In the second column put:
=Asc(Mid([TheFieldName],2,1))
In the third column put:
=Asc(Mid([TheFieldName],3,1))

Set the sort for all columns Ascending
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Pascal Perrot" <pe***********@emc.com> wrote in message
news:bu**********@public.stna.aviation-civile.gouv.fr...
Is there a way to do an ascii sort with ms-access ?
exemple:
unsorted list= A B a C
default sorted list=A a B C
what I would like to have= A B C a

Thanks in advance for your help
Pascal


Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.