"Fuzzy" logic to look up entered clients

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On the database I have designed after you enter the First name and Last name
of the client it checks to see if they've already been entered and a list of
all the clients with the same name is displayed allowing you to quickly check
if they have already been entered. If they have you just click on that record
and it will take you to the client. This works well in most cases.

The main problem I have is sometimes the name is not spelled exactly the
same; i.e. "John" might be spelt "Jon" etc. I was wondering if anyone new how
to develop a "fuzzy" logic system to check for existing clients by name to
allow for slight discrepancies.

Thankyou for your time reading this and any replies that are tendered.

Brett Kinross
 
Search www.Groups.Google.com for the Soundex function and see what you
think. The Soundex function basically will return Jon given John. Keep in
mind it does have its limits based on the spelling of the discrepancies.

You could also use something like this in a query criteria to return both
John and Jon:
Like "Jo" & "*"
 
Thankyou both for your quick response. I did a quick search and it looks just
what I'm looking for :-)
 
Back
Top