search in a notes field

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.
 
R

RonaldoOneNil

In the criteria row of your Notes Field put

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

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

search two fields 6
Submit Button for a Form? 4
Simple Search Form in Access 2007 5
Append Queries in 2007 5
Combo Box Refuses Choice 8
Custom, Automated Input Masks 2
Parameter Query 8
Syntax for 'search' in Horizontal range? XL2007 2

Top