PDA

View Full Version : MS Access - V and W


AK
11-13-2002, 08:14 AM
When I order records alphabetically, I have discovered that Access treats V and W as the same letter. A sorted list of the records might look like this:[list=1] Walter
Vanessa
Vera
William[/list=1]Maybe that's how you Americans like it ;), but it really messes things up for me. Is there a way around this - a setting I can change or something? I use MS Access 97 at home, but I have no idea what version my host is running.

sdarken
11-13-2002, 12:22 PM
I can guarantee you that any English language version of Access doesn't treat V and W as the same letter and will not sort them as you describe :- at least it would not intend to do this.

Either this is not an English language version or there is another bug :- either your software or your application.