Newby, ..Membercode
hi Swingleft,
oName = "Jans"
no = 5
If Len(oName) <= 4 Then oName2 = oName & no
--
isabelle
Le 2011-12-08 11:56, Swingleft a écrit :
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
|