Alphabet autoincrement

[orange]

KWHAT,

Well there are limitations, I need to set the first two characters as a state and the last two need to be characters as well, so there a multiple groups that need to be assigned a unique ID within the same state therefore I need the last two letters to change incrementally, there can’t be any numerical values in the string .

What exactly does this mean first two characters as a state?

Also, from experience, do not over complicate code structures. Use meaningful field names with single defined purpose. Each field has one meaning and holds 1 piece of info. Don't get too cute where every character in every position of some multi-character code means something. For example,
AA11RCF7 --I've seen things like this
AA --current model
11-- ProductionMonth
R -- Red
C---Child
F --Female
7 -- Size 7

This sort of thing is pure foolishness. You will tie yourself in knots before you know.

Anyway, good luck with your project

[orange]

Thanks, for the steps they really helped, but for my own curiosity how would you go about creating a unique string with four characters, were the two preceding characters must be the state or province.

First I would have a table of States_Provinces with values and work from that.

Join tblState_Prov with 2 copies of TblAlphaChar.. is my first thought

If you need a 4 alpha char unique combinations (forget your Prov/State), you would use 4 copies of TblAlphaChar.

BUT, I am not condoning nor encouraging this sort of thing, there are other options.

Because something CAN be done, doesn't mean it SHOULD be done. Focus on WHAT, before getting too involved in HOW.