"Fuzzy" logic to look up entered clients

[Brett Kinross]

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

 

[PC Datasheet]

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" & "*"

 

['69 Camaro]

Hi, Brett.

Try the following link for lots of links and overviews of the Soundex( )
function:

http://groups.google.com/groups?hl=...G=Search&meta=group=microsoft.public.access.*

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)

 

[Brett Kinross]

Thankyou both for your quick response. I did a quick search and it looks just
what I'm looking for

 

['69 Camaro]

You're welcome!

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)