Soundex

[LCalaway]

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

 

[Marshall Barton]

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.

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)

 

[LCalaway]

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