In a query (in criteria) how do I promp for a "substring"?

[Guest]

I need to have the query promp for an input, and with that input, I want to
return all the entries that contain such input as a substring. Thank you.

 

[Allen Browne]

In query design, in the criteria row under the text field you want to
search, enter:
Like "*" & [Search for what] & "*"

Use any name you wish if you don't like "Search for what". As long as it is
not actually a field name or a reserved word, Access will understand it as a
parameter.