ORDER BY involving special characters (1 Viewer)

I need to order by a field which contains some names, so a text field.
The problem is that I have some characters like ć, č, š..and so one which we use in our language.
When I use the normal order by feature in report design it orders it well but sometimes it does this:

Current order:

S###
S###
Š###
S###
S###
Š###

and so on..
The order which I need:

S###
S###
S###
S###
Š###
Š###

So I need Š to come after S, like it is in our alphabet but Access mixes it up, I suppose access sees both S and Š as S.
How could I fix this?
Thanks

EDIT: Seems I only had to change under Access Option/Popular the New database sort order to the one which fits my region. (Office 2007)

Hello1 said:

EDIT: Seems I only had to change under Access Option/Popular the New database sort order to the one which fits my region. (Office 2007)

Click to expand...

I take that to mean that this thread is solved, hence I am marking it solved!