Wild Card Searches with Brackets

[Moxioron]

Hello.

I want to prompt the user to enter a merchant name, but want the results to return close matches.

I know how to use the wildcard in the Criteria field of the query, but I want to use brackets.

I know that "*Southwest*" Will return Southwest Airlines.

So I tried *[Southwest Airlines]* and it treats the criteria like a text string.

Thank you.

 

[GinaWhipp]

Try...

Like "*" & [Enter Merchants Name] & "*"