Solved

Fuzzy Queries?

Posted on 1998-07-31
5
195 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

738 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