Hi,
You can try using Like and the wildcard *

Your criteria could be something like:

Like '*emp*'

which will find all matches where that field contains "emp"

--
HTH
Dan Artuso, Access MVP


"Roger in Diego" Roger in wrote in message
...
Novice needs help. I am wondering if you can design a query that will 'hit'
on a partial field match like the "Find" feature does. Thanks