How do I set up a free text search in Access?

S

Sarah

I have designed a form in Access which contains buttons that run queries on
records in certain categories. What I now need to do is add a free text
search function so that users can type one word in and it will bring back all
records containing that word.

It is a while since I have used Access and and help would be greatly
appreciated.
Many thanks, Sarah
 
K

Klatuu

would that be for every field in the table, or just a specific field? If it
is one field, then create a query and in the criteria row of the query:

InStr([MyField],[Enter Word]) > 0
 
Top