wildcards to search words in access

[Legget]

I have a 'Notes' field and need to create a query for a specific word in the
field to return only records with that word but I cant seem to get it to
work. I can only get returns for the records that have the word as the first
word of the field. This should be simple but I have obviously missed
something!!!!! errrr!¬ any help would be greatly appreciated

 

[John Spencer MVP]

Try the following as criteria
Like "*" & [What Word?] & "*"

If that fails then try
Like "%" & [What Word?] & "%"

Different versions of SQL have different wildcard characters.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

 

[RonaldoOneNil]

Like "*yourword*"

or

Like "*" & [Enter Search Word] & "*"