Hi there,

i try to create a membercoding.. made out of the first 4 letters of the
lastname and a following number.

lastnames
jansen JANS1
jansen JANS2
janssen JANS3
jansons JANS4
jan JAN1

so when i type in a new member with the name

Jansma it generates the code JANS5

....

al also need this for access..
where i'm trying to create a big member database..

thanks for all the help