Like function with wild card and parameter prompt
In the design view of a query, in the Criteria section I have Like [Enter Code] to prompt the user for a code that is searched for a similar (not exact match) in a table. But I need to include the * wildcard before and after what the user enters to get the desired results.
How can this be achieved without having to get the user to enter the * themselves at the prompt? Doing Like *[Enter Code]* automatically places quotes around the prompt causing it to literally search for an actual * character instead of a wildcard.
Thanks for any replies.
EDIT: Colleague found the correct combination of '',&,* below.