Making a Query Search without Exact Name

[amanda_27]

I currently have a database set up with multiple queries such as a city search and address search. I have a form that allows you to search from these queries but I am trying to be able to put something in such as "Commerce" so I can still get results for "Commerce Township. "

I am trying to also be able to just put in a street name to the address query and have it come up with a list instead of an exact address.

I've been reading and I think I need to change something in the query set up but am unsure, I would greatly appreciate being told if either is possible and how to go about implementing them.

Thanks!

 

[mole999]

in SQL you would use commerce% and let the percent return all matches

 

[james_lankford]

I don't think that works for Access --- only Oracle, SQL Server, MySQL and other "real" databases

I think for Access you have to use
commerce*