Hello,

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.


Cheers,
Dustin

EDIT: Colleague found the correct combination of '',&,* below.

In the Criteria of the query design view use:

Like '*' & [Enter Code] & '*'