[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

Fuzzy Queries?

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
stepherd
Asked:
stepherd
1 Solution
 
bharris1Commented:
I think you should take a look at the - Like - SQL operator.


0
 
MLNAUMANNCommented:
Put this in the critera field: Like  * Kennedy * Ethics *
Or any combination of the words that you are looking for.
0
 
stepherdAuthor Commented:
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
 
bknouseCommented:
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
 
stepherdAuthor Commented:
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

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now