Soundex

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

LCalaway - 16 May 2005 03:39 GMT

Hello -
I am trying to create an Update query to populate a field called "SoundVal"
wherein I convert a "LastName" field to a Soundex value. I have found
multiple instances of Code available on the web wherein if I use a form I
can determine the Soundex value for a "LastName" one at a time. I have
created a Module (function) called GetSoundex which I copied from an example
prepared by Doug Steele in the Apr 2005 issue of Smart Access, but am
stumped as to how to create the necessary query.

Any help regarding the necessary methodology and query code would be very
much appreciated.

Thank you.

LCalaway

Reply to this Message

Marshall Barton - 16 May 2005 04:33 GMT

>I am trying to create an Update query to populate a field called "SoundVal"
>wherein I convert a "LastName" field to a Soundex value. I have found
[quoted text clipped - 3 lines]
>prepared by Doug Steele in the Apr 2005 issue of Smart Access, but am
>stumped as to how to create the necessary query.

It doesn't really matter what function you want to use. As
long as you're using a Jet table, which can use any Public
function any of your standard modules, it's just a simple
UPDATE query:

UPDATE yourtable SET SoundVal = GetSoundx(LastName)

Signature

Marsh
MVP [MS Access]

Reply to this Message

LCalaway - 16 May 2005 04:53 GMT

Thank you for your help. Gave me a little more confidence in what I had
done to that point. Once I changed the name of the module I had created
from GetSoundex (I had used the same name for the Module as for the
function) my query worked.

LCalaway

>>I am trying to create an Update query to populate a field called
>>"SoundVal"
[quoted text clipped - 12 lines]
>
> UPDATE yourtable SET SoundVal = GetSoundx(LastName)

Reply to this Message