In my MS Access & VB database application I have a field called rev, which is a revision to specification of criteria according to which an inspection to product takes place. Every time a rev for the specs is accepted and approved, the VB code should assign a rev name (which is a character designation) to it. The revs go in this fassion: A, B, C, .... X, Y, Z, AA, AB, AC, ...... ZX,ZY, ZZ. My question is how can I accomplish that. I tried to look for a ToNumber Function to change the "A" to its number value which lets say is the number 20, then I add 1 to this "20" which becomes 21 then if such function exists I do ToChar(21). But a problem would arise when I reach the Z and I follow the same logic I will not be able to get from Z to AA but I will get somether characted. Could some one help me please?