We help IT Professionals succeed at work.

Fuzzy Queries?

stepherd
stepherd asked
on
Medium Priority
215 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.
Comment
Watch Question

Commented:
I think you should take a look at the - Like - SQL operator.


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

Author

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).  
Commented:
Unlock this solution and get a sample of our free trial.
(No credit card required)
UNLOCK SOLUTION

Author

Commented:
Thank you.  This helps a bunch.  My apologies to MLNAUMANN if I was to inexpert to infer this from his/her answer.  
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a sample view!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.