Thread
:
"any part of field" query
View Single Post
#
3
October 3rd, 2004, 08:49 PM
Dan Artuso
external usenet poster
Posts: n/a
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
Dan Artuso