alpha sort apostrophe out of order

[Guest]

I am still new to Access so please be kind. Aplha sort on a text field -
words that contain apostrophe are not in right order. The list sorted as:

I LOVE YOU
IF TOMORROW COMES
I'LL BE SEEING YOU
ILLUMINATE
I'M OK NOW

Those that start with quotes or special characters are in correct order at
beginning of list.

Also, in same file, last names that contain apostrophe (O'Brian) are at
beginning of O but in no order at all.

what now?

 

[Joseph Meehan]

I am still new to Access so please be kind. Aplha sort on a text
field - words that contain apostrophe are not in right order. The
list sorted as:

I LOVE YOU
IF TOMORROW COMES
I'LL BE SEEING YOU
ILLUMINATE
I'M OK NOW

Those that start with quotes or special characters are in correct
order at beginning of list.

Also, in same file, last names that contain apostrophe (O'Brian) are
at beginning of O but in no order at all.

what now?

I believe the sort order is:

0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` {
| } ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Apostrophes (') and hyphens (-) are ignored, with one exception: If two text
strings are the same except for a hyphen, the text with the hyphen is sorted
last.

There is no one sort order. Main frames commonly use one and PC's
commonly use another and there are others and sub verities.

I might suggest that adding a space after the ' might give you something
closer to what you want. Maybe someone who does this more often than I will
offer a more authoritative answer and a better solution.

 

[Guest]

I was thinking same thing about adding a space after, but it is time
consuming to go back and change all of them. thanks. is crazy lol

I am still new to Access so please be kind. Aplha sort on a text
field - words that contain apostrophe are not in right order. The
list sorted as:

I LOVE YOU
IF TOMORROW COMES
I'LL BE SEEING YOU
ILLUMINATE
I'M OK NOW

Those that start with quotes or special characters are in correct
order at beginning of list.

Also, in same file, last names that contain apostrophe (O'Brian) are
at beginning of O but in no order at all.

what now?

I believe the sort order is:

0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^ _ ` {
| } ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Apostrophes (') and hyphens (-) are ignored, with one exception: If two text
strings are the same except for a hyphen, the text with the hyphen is sorted
last.

There is no one sort order. Main frames commonly use one and PC's
commonly use another and there are others and sub verities.

I might suggest that adding a space after the ' might give you something
closer to what you want. Maybe someone who does this more often than I will
offer a more authoritative answer and a better solution.

 

[Joseph Meehan]

I was thinking same thing about adding a space after, but it is time
consuming to go back and change all of them. thanks. is crazy lol

I am still new to Access so please be kind. Aplha sort on a text
field - words that contain apostrophe are not in right order. The
list sorted as:

I LOVE YOU
IF TOMORROW COMES
I'LL BE SEEING YOU
ILLUMINATE
I'M OK NOW

Those that start with quotes or special characters are in correct
order at beginning of list.

Also, in same file, last names that contain apostrophe (O'Brian) are
at beginning of O but in no order at all.

what now?

I believe the sort order is:

0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^
_ ` {

} ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Apostrophes (') and hyphens (-) are ignored, with one exception: If
two text strings are the same except for a hyphen, the text with the
hyphen is sorted last.

There is no one sort order. Main frames commonly use one and
PC's commonly use another and there are others and sub verities.

I might suggest that adding a space after the ' might give you
something closer to what you want. Maybe someone who does this more
often than I will offer a more authoritative answer and a better
solution.

How doing a replace?

 

[Guest]

After looking at the sort order again, the apostophe is before any alpha
characters. should not have to add spaces to fix this. my english teacher is
turning over in her grave lol

BrokeLady wrote:
I am still new to Access so please be kind. Aplha sort on a text
field - words that contain apostrophe are not in right order. The
list sorted as:

I LOVE YOU
IF TOMORROW COMES
I'LL BE SEEING YOU
ILLUMINATE
I'M OK NOW

Those that start with quotes or special characters are in correct
order at beginning of list.

Also, in same file, last names that contain apostrophe (O'Brian) are
at beginning of O but in no order at all.

what now?

I believe the sort order is:

0 1 2 3 4 5 6 7 8 9 (space) ! " # $ % & ( ) * , . / : ; ? @ [ \ ] ^
_ ` {
} ~ + < = > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

Apostrophes (') and hyphens (-) are ignored, with one exception: If
two text strings are the same except for a hyphen, the text with the
hyphen is sorted last.

There is no one sort order. Main frames commonly use one and
PC's commonly use another and there are others and sub verities.

I might suggest that adding a space after the ' might give you
something closer to what you want. Maybe someone who does this more
often than I will offer a more authoritative answer and a better
solution.

How doing a replace?