Use the Like operator and the * wildcard in the criteria:
Like "*" & [enter last name] & "*"
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"john" <jo**@test.comwrote in message
news:0I********************@casema.nl...
In a query I have put the following criteria in a field:
[enter last name]
Now I would like the query to use this user input to search with
wildcards. So, if he enters john, in fact the query should search like:
*john*
Is that possible?
Thanks,
john