Auto numbering....

[Red Devil]

We have a part numbering system that is currently like this, 11Y22 where 22 increments by one until it gets to 99 where it then goes back to 0, once it goes to 0 the letter increments to Z in this case, now once the last three characters get to Z99, then the 11 gets incremented eg, 11Z99 will become 12A00. Hope that is clear

My question is, can this system be implemented into the auto numbering in Access?

Thanks in advance

RD

 

[Rabbie]

The standard autonumbering cannot handle this. Its role is to produce a unique numeric key because that is the most efficient for sorting/indexing.

You would be able to implement this system in VBA if you wanted to.

 

[Red Devil]

Damn, I thought as much....mutter grumble

Thanks

RD