Prev: Unable to join 3rd subquery in nested query
Next: Multiple Values in a Query Criteria
From: orange via AccessMonster.com on 26 Feb 2010 14:25
Karen Ahmad wrote:
>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
What is your code to do the sort? Do you have options that could be used?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/201002/1

 | 
Pages: 1
Prev: Unable to join 3rd subquery in nested query
Next: Multiple Values in a Query Criteria