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