wildcards to search words in access

  • Thread starter Thread starter Legget
  • Start date Start date
L

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
 
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
 
Back
Top