Hello there,
Sorry if this question has been answered before but I could not find a suitable reply in the search.
I wish to designate unique customer codes in my database during data entry.
For example;
Liz Stimp = LS1
Liz Stamp = LS2
Lyne Small = LS3
Lipo Suction = LS4
I have successfully linked the first and surname using a "Left 1st letter" in the expression but I do not understand how to add a 'unique' number to the code to give me the result I am after.
Expression so far is .....Left([First Name],1)+Left([Surname],1)
I do hope someone can help me as these customer codes have been the basis of my business so far and any correction would mean relabelling the whole shop!!!
Thank you for any replies
Regards Rodnee
Sorry if this question has been answered before but I could not find a suitable reply in the search.
I wish to designate unique customer codes in my database during data entry.
For example;
Liz Stimp = LS1
Liz Stamp = LS2
Lyne Small = LS3
Lipo Suction = LS4
I have successfully linked the first and surname using a "Left 1st letter" in the expression but I do not understand how to add a 'unique' number to the code to give me the result I am after.
Expression so far is .....Left([First Name],1)+Left([Surname],1)
I do hope someone can help me as these customer codes have been the basis of my business so far and any correction would mean relabelling the whole shop!!!
Thank you for any replies
Regards Rodnee