Newby, ..Membercode
 

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

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