View Single Post
  #1  
Old August 17th, 2007, 02:22 AM posted to microsoft.public.access.tablesdbdesign
Erika M.
external usenet poster
 
Posts: 16
Default Creating a 'word search' in a query

I am building a reference FAQs/Answers database in which we will be doing
searches using keywords. Can you tell me the best way to build this search
engine? I have built a query and the criteria for the "Question" field looks
like this as of now:

Like "*" & [Enter Keyword] & "*"

However, that only allows me to enter one word at a time, and it has to be
spelled exactly the way it is spelled in the table in order for it to pull
up. I would know to use * and other expression helpers, but others running
viewing this form would not know. How can I give users the option to enter
more than one keyword? Or better yet, what is the best advice you can offer
someone who is building a search engine for their table.

Thank you again!! You all are great!