By using wild cards. To find records where the word "and" exists in a
specific field you would use something like the following.
Field: Expr1: " " & YourFieldName & " "
Criteria: Like "* and *"
Note that I have added a space before and after the field. This is so you
can find matches on just AND and not on hANDle, rANDom, etc and so that if
your text begins with AND or ends with AND, you will pick up those records
also.
--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..
