How can I make a query for a key word in a column?

[Guest]

I set up a database for frequenty asked questions pertaining to specific
products that our company produces. I want to set up a query that will
prompt a user to enter a key word, then search all questions that have that
key word in it. Does anyone think they can help? I am pretty new at this,
so I appreciate any help I can get.

 

[Guest]

Use this for criteria in your query --
Like "*" & [Enter search key word] & "*"

 

[Michel Walsh]

Hi,


With Jet (dot-mdb files), you are likely limited to one word and one field,
with the operator LIKE which accepts wildcard * and ? (with DAO).

With MS SQL Server, some version have Full Text search capabilities, somehow
more powerful than the LIKE operator. Try to get the Book on line tool that
ships with MS SQL Server, or a book like Inside MS SQL Server, or a
newsgroup dedicated to MS SQL Server.


Hoping it may help,
Vanderghast, Access MVP

 

[Guest]

Karl you rock! Yes. It fixed my problem....now if you can riddle me this
one batman. How do I do a query inside a query? If the first query prompts
the user to make a selection, then once it is made a second query can prompt
the user to narrow the focus down even further. Do I need multiple tables,
or can I tie the second query into a second column somehow. Thanks again for
the help!

Use this for criteria in your query --
Like "*" & [Enter search key word] & "*"

I set up a database for frequenty asked questions pertaining to specific
products that our company produces. I want to set up a query that will
prompt a user to enter a key word, then search all questions that have that
key word in it. Does anyone think they can help? I am pretty new at this,
so I appreciate any help I can get.

 

[Guest]

Michel,

Thanks for the response. I think I have it taken care of. I had a second
question, since you were nice enough to respond to the first one. Do you
know how to establish a query inside a query. The first query will prompt
the user to select a catagory, then once that catagory is selected, the
second query will narrow the selected topic down? Any thoughts? Thanks
again!

 

[Michel Walsh]

Hi,

You use the first query as if it was a "table" for the second query, so,
we can see the "construction" as a query embedding another query. Open the
query designer to start the second query, and specify the first query as the
"table" you want to work with.

The user interface is smart enough to ask for all the parameters, at
whatever level of embedment (there is a limit, but it is relatively high,
and depend on each version) they are. Furthermore, if the name of the
parameter is the same, it is likely to be asked just once.




Hoping it may help,
Vanderghast, Access MVP