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)
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)
Last edited: