Query any part of the field

[spleewars]

quick question: in a criteria i need to set a code than even the slightest amount of letters return a search. for example in the "Description" column:



"Dell Inspirion D5000"

Lets say a user writes 'pirion' in the criteria. All the records with those letters will return a search. I tried 'like "*" but doesn't work.

[June7]

Need wildcard on both ends. Try:

Like "*" & criteria & "*"