How to search for userdefined keyword in Access 2003 query?

[Guest]

Access 2003 or InfoPro 2003

I am trying to allow any user to respond to a query criteria prompt and
allow him to search for a keyword (typically identified as a *criteria* or
like criteria).

For example, I have a database that stores a list of problems, and each
problem is fully described when it is input to the database. I want to enable
co-workers to search for a keyword in the problem description by using a
query form that prompts for a keyword like "altitude," although that may not
be the only work in the problem description.

 

[Rick B]

In your query, under the field in which you wish to search, put....


Like "*" & [Enter Phrase to Search] & "*"



Or similar.

 

[Guest]

Thank you : )

In your query, under the field in which you wish to search, put....


Like "*" & [Enter Phrase to Search] & "*"



Or similar.


--
Rick B

Access 2003 or InfoPro 2003

I am trying to allow any user to respond to a query criteria prompt and
allow him to search for a keyword (typically identified as a *criteria* or
like criteria).

For example, I have a database that stores a list of problems, and each
problem is fully described when it is input to the database. I want to enable
co-workers to search for a keyword in the problem description by using a
query form that prompts for a keyword like "altitude," although that may not
be the only work in the problem description.