Newby, ..Membercode

[Swingleft]

Hallo,
i'm very new in Access..
ik ben een nieuweling in Access.

I would like to create a unique code by using the last name and a no.

Making this by using the fisst 4 letters of the Lastname and a following
number.
f.i.
Lastname Janssen will then be JANS1
Lastname Jansen -> JANS2 and so on..

if the lastname is shorter then 4.

then only us the name and a following no.

f.i.

ES1


any help will be great.

gr.

Swingleft

 

[isabelle]

hi Swingleft,

oName = "Jans"
no = 5
If Len(oName) <= 4 Then oName2 = oName & no