1 Query 2 spelling options

[Ron]

Is there a way that I can create 1 Query based on 2
spelling versions. I need to have a query based on a city
name. In the table I have a city that is spelled 2
differant ways. (ex. De Pere and DePere) The Query
prompts only once for the user to enter the city name. Is
there a way to get both spellings with just 1 query and
one user entry? Thanks

 

[Jeff Boyce]

Ron

Wouldn't an obvious alternative be to "fix" the "errors"? Does the Post
Office allow two spellings?

There's a generic way to look for something like, but it doesn't have the
flexibility you'd need to handle anything other than this one example. And
it might not even work for that one. Take a look at the "Like" and
"wildcard" listings in Access HELP.

If your CityName criterion was:
Like * & [Enter some part of the city name] & *
and someone entered "Pere", you'd get both spellings. But you'd also get
any other cities with the string "pere"!

Good luck!

Jeff Boyce
<Access MVP>