Sort Order with parentheses in text field
Sort Order with parentheses in text field
(OP)
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?
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?
RE: Sort Order with parentheses in text field
Duane
Hook'D on Access
MS Access MVP
RE: Sort Order with parentheses in text field
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...
RE: Sort Order with parentheses in text field
RE: Sort Order with parentheses in text field
Not sure how I missed this all these years.
"Never too old to learn", eh?