A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Creating a 'word search' in a query



 
 
Thread Tools Display Modes
  #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!
  #2  
Old August 17th, 2007, 08:10 PM posted to microsoft.public.access.tablesdbdesign
Jeff Boyce
external usenet poster
 
Posts: 8,621
Default Creating a 'word search' in a query

Erika

You don't really expect Access (just a dumb computer program) to "know" that
someone misspelled the word "transport" when they entered it in response to
your parameter prompt, right?g If you can come up with a pattern for ALL
the ways folks might creatively misspell ALL words, you could program Access
with that ?!?

And the ability to search for more than one term is going to require a bit
of work. After all, do you want them to search for Word1 AND Word2, or
Word1 OR Word2? And how many Words do you want to allow (again, Access is
dumb, you'll have to be specific)?

You might want to look into building a search form, rather than trying to do
this via a query's parameters. Search on-line for Access-related search
form approaches.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Erika M." wrote in message
...
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!



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:06 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.