Search various fields using a keyword in Access

[Guest]

I want to set up a search option that will allow my users to search various
fields for a specific word, and return all records which contain that word.
Is there any way to do this? It is one table containing the details of many
documents within a library.

 

[John Vinson]

On Fri, 15 Apr 2005 08:43:02 -0700, "Donna O" <Donna

I want to set up a search option that will allow my users to search various
fields for a specific word, and return all records which contain that word.
Is there any way to do this? It is one table containing the details of many
documents within a library.

You can use a Query with OR logic: to set this up in the query grid,
put

LIKE "*" & [Enter keyword:] & "*"

on the criteria line under each field that you want to search, on
*separate* lines in the query grid.

However, the need to search multiple fields makes me suspicious that
your tables may not be properly normalized. What is the structure of
your table? How many fields? What are some of the fieldnames that you
will want to search?

John W. Vinson[MVP]