search in a notes field

  • Thread starter Thread starter Striker
  • Start date Start date
S

Striker

I know I can place square brackets in a query to get the users input, but
what if I want to look for whatever they input in the string of a notes
field, and if found return those records. Access 2007.
 
In the criteria row of your Notes Field put

Like "*" & [Enter Search String] & "*"
 
Back
Top