search a field for a word that is not at the beginning

  • Thread starter Thread starter les levine
  • Start date Start date
L

les levine

I am putting together a database, I need to be able to do
a query search on memo fields or text fields for any word
within it . What can I do to accomplish that?
 
I am putting together a database, I need to be able to do
a query search on memo fields or text fields for any word
within it . What can I do to accomplish that?
Click to expand...

As criteria for that memo field, use:
Like "*" & [Enter Search Word] & "*"
 
Try Criteria of

Criteria: LIKE "*" & [Find what word?] & "*"

or if you are using a project vice an mdb

Criteria: LIKE "%" & [Find what word?] & "%"
 
Back
Top