finding words in text

K

Kathleen Hogan

I need to generate a query that looks for certain words that are part of a
text field but not all of it. When you use "find" you can look for part of a
field, but the query wants to look for the complete field. How do I get it
to find all fields containing "word a" or "word b" or "word c"?

Thanks for any help you can give.
 
K

KARL DEWEY

Use this for criteria --
Like "*"& [Enter search word] &"*"

Use this as criteria for every field you want to search but put it on
different rows for each field. Type it once then copy and paste to the other
rows so that there will not be any differences.
 
Top