The results of a soundex search to be sorted so that exact matches (or partial matches at the start of the string) were at the start of the list, so I added an expression in the order by clause.
wheresoundex(personlastname) = soundex('knapp')
orderby case when personlastname like 'knapp%' then 0 else 1 end,
Thank you! Thank you! I just finished reading this document, which was part of a link in the recent Buzz newsletter. I have printed it for others to read, especially those skeptical on the powers of Access and its capabilities.