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