Seeking Help on Extracting Letters from name

[MonarTech]

Hi all: MS Access 2003. I have two text fields family_name and given_name I need to extract 1st, 2nd & 5th letter of family_name along with 2nd & 3rd letter of given_name to form a link_key field. If either name has insufficient letters the missing letter is replaced by the numeral 2. Does anybody know how to help me acheive this please!

 

[The_Doc_Man]

Look up string function MID or MID$ in the Help files. Also, function LEN to determine when a name isn't long enough.

It will do what you want.

 

[MonarTech]

Manny Thanks

Thank you I will do that, greatly appreciate the lead