function help to append alphabets to variable?

[akapag22]

Hi friends,



I want to append alphabets at end of variable called customertag in the following way
If the Customer Tag is 100 (i get this from a dropdown box populated from another table)
The first time it shoulbe be 100a , 2nd time 100b, third time:100c..so on

I store the the following values in table called CustomerActivity..so Ic an check the previous value from this table. It the most recent was 100c the next tag sgould be 100d and when it reaches 100z it should be 100aa again.

Please suggest the best way to do this...Thank you

[June7]

Generating custom unique identifier is a common topic in forum. For a start, review https://www.accessforums.net/forms/a...ing-23329.html