Re: [MSAccessProfessionals] ALPHABETIZATION

Access doesn't simply follow the raw ASCII values of characters; instead, it uses the collation order defined by your computer's regional and language settings. 

In a default "General" sort order, values beginning with a space come first, followed by those enclosed in quotation marks, and then items starting with a minus sign (which sort before those starting with a plus sign); for any other symbol (like "#"), while its ASCII code would normally place it before letters, the regional collation often treats letters as more significant so that, for example, "AC Adapter" (starting with A) comes before "#10", and since text is compared character‐by‐character, a string beginning with "9" sorts before one starting with "a" (as in "adapter audio TV") .

On Sun, Jul 20, 2025, 2:58 AM Phil, WF3W via groups.io <WF3W=JUNO.COM@groups.io> wrote:

Gday all,

 

I know you're keeping hydrated...

 

A simple look-up, in Access, had me stumped for many, long minutes, as to not being in alphabetical order, in a table.

 

Online was not helpful, so, I ask:

 

when ACCESS alphabetizes, what is the hierarchy/order, e.g., spaces, punctuation marks, e.g., #, numbers, etc.

 

Some brain-busters:

 

AC Adapter appears before #10; adapter audio TV is after 9v batt

 

Thanks for your help.

 

Phil, WF3W

 

_._,_._,_

---

Groups.io Links:

You receive all messages sent to this group.

View/Reply Online (#116703) | Reply to Group | Reply to Sender | Mute This Topic | New Topic
Your Subscription | Contact Group Owner | Unsubscribe [sugeng.panjalu.access@blogger.com]

_._,_._,_