473,326 Members | 2,111 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

ascii sort

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
2 2662
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

7
by: Nova's Taylor | last post by:
Hi folks, I am a newbie to Python and am hoping that someone can get me started on a log parser that I am trying to write. The log is an ASCII file that contains a process identifier (PID),...
5
by: lkrubner | last post by:
I know I'm missing something obvious, but I looked hard at this page and did not see the format of the return specified: http://us3.php.net/manual/en/function.ord.php >From the limited example...
16
by: chunhui_true | last post by:
I know in ASCII '\r' is 0x0d,'\n' is 0x0a. But some say ASCII characters in UTF8 is unchanged. Now I want to know in UTF8 '\r' and '\n' are already 0x0d and 0x0a?? Could anybody can tell me? Very...
12
by: wob | last post by:
Hi there, I wish to show some special characters such as the char for "alpha" and the symbol for degrees.. Anyone please give me some suggestions how to do that? Thank you very much! Owen
4
by: cok | last post by:
Hi, All I have a question about Encoding.ASCII.GetString. I want convert a byte array to a string, I use Encoding.ASCII.GetString(byteArray) (byteArray is something like ) but the retult...
4
by: crowell | last post by:
I'm using the ID3 tag of an mp3 file to query musicbrainz to get their sort-name for the artist. A simple example is "The Beatles" -> MusicBrainz -"Beatles, The". I then want to rename the mp3...
17
by: Gregor Kovač | last post by:
Hi! Does DB2 handle extended ASCII table? Example: VALUES(CHR(65)) =A VALUES(CHR(129)) =null, but according to www.asciitable.com should be u with umlaut. Any idea ?
399
by: =?UTF-8?B?Ik1hcnRpbiB2LiBMw7Z3aXMi?= | last post by:
PEP 1 specifies that PEP authors need to collect feedback from the community. As the author of PEP 3131, I'd like to encourage comments to the PEP included below, either here (comp.lang.python), or...
13
by: Eps | last post by:
Hi there, I believe all strings in .net are unicode by default, I am looking for a way to remove all non ascii characters from a string (or optionally replace them). There is an article on...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.