Sorting does not distinguish between Œ and OE or Æ and AE

K

Karen Ahmad

Hi -

I have a database in Microsoft Access 2002 - 2003 file format. It is being
accessed by a VB6 program using ADODB. One of the fields in the database
contains one word per record. The word is either an English word or a French
Canadian word. When I sort on this field the words that differ by Å’ and OE
or Æ and AE are mixed together. For example,

PHÅ’NIX
PHOENIX
PHOENIX
PHOENIX
PHÅ’NIX
PHOENIX

Is there any way for these words to be sorted separately. For example,

PHÅ’NIX
PHÅ’NIX
PHOENIX
PHOENIX
PHOENIX
PHOENIX

Any help on this would be greatly appreciated.

Thank you -
Karen Ahmad
 
O

orange via AccessMonster.com

Karen said:
Hi -

I have a database in Microsoft Access 2002 - 2003 file format. It is being
accessed by a VB6 program using ADODB. One of the fields in the database
contains one word per record. The word is either an English word or a French
Canadian word. When I sort on this field the words that differ by Å’ and OE
or Æ and AE are mixed together. For example,

PHÅ’NIX
PHOENIX
PHOENIX
PHOENIX
PHÅ’NIX
PHOENIX

Is there any way for these words to be sorted separately. For example,

PHÅ’NIX
PHÅ’NIX
PHOENIX
PHOENIX
PHOENIX
PHOENIX

Any help on this would be greatly appreciated.

Thank you -
Karen Ahmad
Click to expand...
What is your code to do the sort? Do you have options that could be used?
 
J

Jerry Whittle

Len("PHÅ’NIX") = 6

Len("PHOENIX") = 7

Therefore you could sort on the field twice in a query. Once the normal way
then second on the field looking something like:

TheLength: Len([FieldName])

That should keep the variations seperated.
 
Top