I've created an address book database for one of my classes, and one of the requirements is various parameter queries. I chose one to be the ability to view contacts according to the city or town in which they live; however, my professor has suggested I use "Like" criteria, so that a viewer may search either "St. Louis," "St Louis," or "Saint Louis," to view contacts living in STL.
The proposed solution has been: Like "*"+[Enter City:]+"*" . However, this does not work. I would attempt something like: Like "*" & [Louis] & "*", but this would make the parameter specific to contacts living only in areas with "louis," in the city name.
Does anyone know of another possible solution?
Thank-you for your time,
Cameron