Hello again...
Use Access 2k7.
I have a table streets with street_id, street_name...fields
I have a module "functions" with follow code...
Public Function Soundex(strName As String) As String
Dim strCode As String, strCodeN As String
' Length of original string, last code returned, looping...