sorting in ACCESS 2000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The following list appears as is when I sort it in Access 97 or Oracle.
T_E_OWNER
ACCLDAYS
AGYID
AIDCAT
RSNHRSCH
S-OR-A
S-OR-M
SANCTION


SCTDFLT
SEX
TMWAFREL
ZZZZ

However, when I sort it in Access 2000 or Excel 2000 it appears as
T_E_OWNER
ACCLDAYS
AGYID
AIDCAT
RSNHRSCH
SANCTION
SCTDFLT
SEX
S-OR-A
S-OR-M
TMWAFREL
ZZZZ

Does someone kwow what to do to make it sort the first way which is the
correct way.
 
Hi,


Under Win32, the - and the ' are transparent characters. You (SHOULD)
get the same sorting in any product form Office, and from any ordering
relaying on Win32 API.




"""""""""""""""""""""""""""""""""""""""""""""""""""
Dr. GUI replies:
Actually, the Win16 and Win32 sorting algorithms are almost identical. In
general, the order is this:

1.. Non-alpha-numeric (punctuation) characters in ASCII or ANSI order
2.. Numeric characters in numeric order
3.. Alphabetic characters in case-insensitive alphabetic order
For Win32 it is the same, with two exceptions: the hyphen or minus (-)
symbol and the single-quote or apostrophe ( ' ). These two characters are
ignored when sorting strings because they are allowed to be embedded in
English-language words. For example, "its" and "it's" and "co-op" and
"coop." The presence of these characters embedded in words causes certain
searches to break incorrectly, so they are changed to be treated just like
other diacritical marks embedded in text strings; that is, they're ignored."

"""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""""




Hoping it may help,
Vanderghast, Access MVP


"menchi(removethis)@dor.state.ma.us"
 
Back
Top