Solved

Fuzzy Queries?

Posted on 1998-07-31
5
188 Views
Last Modified: 2006-11-17
When creating a parameter query, how does one specify that the query should look for any combination of
words in the searched field?  In other words, I have a database in which one of the fields is journal titles.
 How would I create a parameter query that could find an entry like "The Kennedy Institute of Ethics Journal 1:2"
 if the user supplied "Kennedy Institute Ethics," or maybe even just "Kennedy" to the query?  Yes I'm new to Access.  Thanks.
0
Comment
Question by:stepherd
5 Comments
 
LVL 1

Expert Comment

by:bharris1
ID: 1957798
I think you should take a look at the - Like - SQL operator.


0
 

Expert Comment

by:MLNAUMANN
ID: 1957799
Put this in the critera field: Like  * Kennedy * Ethics *
Or any combination of the words that you are looking for.
0
 

Author Comment

by:stepherd
ID: 1957800
Sorry, probably a more expert Access developer would be able to infer this from you answer, but I was interested in seeing how this could be accomplished using a *parameter* query.  It seems as though your answer applies to only straight queries.  SSD (sorry so dense).  
0
 
LVL 6

Accepted Solution

by:
bknouse earned 150 total points
ID: 1957801
Actually MLNAUMANN was on the right track.  The way to make this a parameterized query is to enter into the criteria:

Like "*" & [Enter search criteria] & "*"

This will prompt the user with a dialog box asking:
Enter search criteria:  
Whatever the user types will replace the bracketed section of the above criteria.  
If the user doesn't know the contiguous string, they would have to enter the * wildcard operator: example Kennedy * Ethics.  The parameterized query only supplies the starting and ending wildcards.

Brent
0
 

Author Comment

by:stepherd
ID: 1957802
Thank you.  This helps a bunch.  My apologies to MLNAUMANN if I was to inexpert to infer this from his/her answer.  
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Today's users almost expect this to happen in all search boxes. After all, if their favourite search engine juggles with tens of thousand keywords while they type, and suggests matching phrases on the fly, why shouldn't they expect the same from you…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now