finding words in text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count text values in a Access Field 0
MS word Find and Replace using Regex - Help required 0
Expresion help! 5
Extracting a word from a long text field 5
Making a query that shows a value based on another value. 3
Blank and Numeric field Expresion 1
Creating OR, AND query in access and getting parametrs frm access 2
Split column contents (de-concantenate) 7

Back
Top