Has anyone used a wildcard in a parameter search in Access?

[Guest]

I am trying to set up a query that will act like a "Find" in any part of the
field. I would like to create a parameter search where the user is prompted
to type in the text being searched in a particular field and the query finds
records where that text is included in any part of the field (as opposed to a
parameter search that finds records where the searched text is the only data
in the field).

Has anyone figured out if Access can do this

 

[Guest]

Try this:

Like "*" & [Enter Value] & "*"

RW