AnsweredAssumed Answered

5 Digit Alphanumeric Part Number

Question asked by rufusthedog on Apr 20, 2015

Title

5 Digit Alphanumeric Part Number

Post

I'm trying to create a 5 digit alphanumeric part number. This is what I have so far.

Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^4)+1;1) &  Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^3)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36^2)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Int(id/36)+1;1) & Middle("0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ"; Mod(id;36)+1;1)

This seems to work but when the numbers gets higher in value the lower places disappear. For example when  I go past 1295 part number the lowest digit disappears. I know I'm missing something simple but any help would be appreciated.

Outcomes