Hi ,

I have major sort problem using Access 97 , last alphabet character comes
first when I sort ascending;


In our (Croatian) language letter Z (with accent) is last alphabet
character; so when i sort it goes like this:

Z(With accent)
A
B
C
..
..
..


Please advise

Thanks,
Domac

The sort order is controlled on the General tab under Tools | Options.
Looking there, though, I don't see a choice for Croatian. Is there some
other language there that has the same sort rules?

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Domac" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> Hi ,
>
> I have major sort problem using Access 97 , last alphabet character comes
> first when I sort ascending;
>
>
> In our (Croatian) language letter Z (with accent) is last alphabet
> character; so when i sort it goes like this:
>
> Z(With accent)
> A
> B
> C
> .
> .
> .
>
>
> Please advise
>
> Thanks,
> Domac
>
>

On Tue, 14 Nov 2006 09:34:55 -0500, Douglas J. Steele wrote:

> The sort order is controlled on the General tab under Tools | Options.
> Looking there, though, I don't see a choice for Croatian. Is there some
> other language there that has the same sort rules?

It's there in my Access 2002 database options, 6th one down.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail

"fredg" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Tue, 14 Nov 2006 09:34:55 -0500, Douglas J. Steele wrote:
>
>> The sort order is controlled on the General tab under Tools | Options.
>> Looking there, though, I don't see a choice for Croatian. Is there some
>> other language there that has the same sort rules?
>
> It's there in my Access 2002 database options, 6th one down.

My fault. I was looking in Access 97.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

"Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
news:(E-Mail Removed)...
> "fredg" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
>> On Tue, 14 Nov 2006 09:34:55 -0500, Douglas J. Steele wrote:
>>
>>> The sort order is controlled on the General tab under Tools | Options.
>>> Looking there, though, I don't see a choice for Croatian. Is there some
>>> other language there that has the same sort rules?
>>
>> It's there in my Access 2002 database options, 6th one down.
>
> My fault. I was looking in Access 97.

But so is the original poster! :-)

<quote from original post>
I have major sort problem using Access 97 , last alphabet character comes
first when I sort ascending;
</quote>

--
Brendan Reynolds
Access MVP