How can i create a query on text input to return closest match?

[Vanita]

I would like to create a text based parameter which will return the closest
match?
e.g Drink is the search citeria, the search will look for the word drink in
every record and bring up those with the closest match

 

[John Spencer]

Can you explain what you mean by closest match?

Looking for the word Drink in a field and returning all the records where
"drink" is included in the field would be simple.

Field: SomeFieldWithText
Criteria: LIKE "*" & [Enter word] & "*"

But if you wanted to enter DRINK and find
Drink or Drank or Drunk or Dink or Rink Or Dunk or ....
in place in the field and rank the records found by the closeness of the
match, then you need to talk to the folks at Google.

I do some matching based on approximations of the entire field to the search
string. It is complex and involves VBA functions.

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..