Wrox Home  
Search P2P Archive for: Go

  Return to Index  

access thread: Access 2000 Sort Order


Message #1 by "steve austin" <saustin@h...> on Thu, 5 Apr 2001 16:25:31
Hi All,

Have a text 20 byte Part field that I am sorting on and for 

some reason the print order is different then what you might expect 



For example Parts display

0-

00

0-1

instead of

0-

0-1

00

Why is this ? Seems like 2000 is ignoring the "-". Is it a default 

language change ? Can I specify an ARABIC sort order instead of UNICODE ? 

Is there any way to correct this ?



This change is also noted when running the query in Access 97 versus 

Access 2000. 97 prints out in the correct order.



Any suggestions greatly appreciated.



Thanks, Steve.


  Return to Index