Hi everyone

I have built a data base that will eventually list well over 1 million items (maybe even several millions) with each item needing a unique serial number.

I am hoping that there is a way to create serial numbers which also includes an alphabet sequence, such as - starting at AAA001 which would change once the numerical number reached 999 and then it would become AAB000 until the next thousand which would then become AAC000, and so on throughout the alphabet.

Being a newbe I am at a loss as to how to create such a serial number, or, indeed even if it is possible at all. If not, then there maybe there is another solution entirely that I am unaware of. I am simply trying to find a simpler system of serial numbers so that I do not have to keyin very long strings of numbers for looking up items etc as the list of items gets bigger.

Any suggestions?

Thanks for any help.

David

Hi David,

I would use a field to auto enter a serial number and then convert that number in the alphabet field using the formula:

Let([

s="ABCDEFGHIJKLMNOPQRSTUVWXYZ";

th=Int(number/1000);

r=Mod(number;1000);

l1=Int(th/26^2);

l2=Int((th-l1*26^2)/26);

l3=Int(th-l1*26^2-l2*26)

];

Middle(s;l1+1;1) & Middle(s;l2+1;1) & Middle(s;l3+1;1) & Right("00"&r;3)

)

Hope that helps,

Best regards,

Ruben van den Boogaard

Infomatics Software

ruben@infomatics.nl