Sort Order with parentheses in text field

vbprgmr · Aug 25, 2014

Hey, Gang -
Have a simple table with a text field which has the following data - sorted ASC:
CH2-(Cb,S)
CH2(CN)-(C)
CH2-(CO,=C)

It appears to ignore the dashes. I cannot find any reference to this issue anywhere. Weird.

Any Help?

dhookom · Aug 25, 2014

I think this has been around for a while. A solution is to use Replace() to replace the hyphen with another character if you need to sort by the field.

Duane
Hook'D on Access
MS Access MVP

vbprgmr · Aug 26, 2014

Thanks, Duane
Wow - been doing this for 45 years and cannot believe I have not run into this before.
Any 'official' explanation / link from, say Microsoft, or any IT group that you know of?
Bummed out, but still looking...

MajP · Aug 26, 2014

http://support.microsoft.com/kb/212144

Same for Access

vbprgmr · Aug 26, 2014

Thanks, All.
Not sure how I missed this all these years.
"Never too old to learn", eh?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Sort Order with parentheses in text field

vbprgmr

Programmer

dhookom

Programmer

vbprgmr

Programmer

MajP

Technical User

vbprgmr

Programmer

Similar threads

Part and Inventory Search

Sponsor