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?

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.



--
Joseph Meehan

Dia duit

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

"Joseph Meehan" wrote:

> 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.
>
>
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>

BrokeLady wrote:
> 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
>
> "Joseph Meehan" wrote:
>
>> 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.
>>
>>
>>
>> --
>> Joseph Meehan
>>
>> Dia duit

How doing a replace?

--
Joseph Meehan

Dia duit

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.
> >>
> >>
> >>
> >> --
> >> Joseph Meehan
> >>
> >> Dia duit
>
> How doing a replace?
>
> --
> Joseph Meehan
>
> Dia duit
>
>
>