Determining the next Alpha Sequence letter for recordid

[Guest]

I am looking for code that will look at the last number(Alpha character) and
set the next alpha value (A11A, A11B, A11C, etc.)

Can anyone point me in the right direction?

 

[Stefan Hoffmann]

hi kf,

I am looking for code that will look at the last number(Alpha character) and
set the next alpha value (A11A, A11B, A11C, etc.)

Chr(Asc(Right(<value>, 1)) + 1)


mfG
--> stefan <--