In access I want to Auto Increment letters instead of numbers i.e ( a,b,c,d….aa,ab,ac,ad……ba,bb,bc,bd…etc….
I am starting with a 'commodity code' something like GEGADZZADA and I want it to Auto Increment to GEGADZZADB and then GEGADZZADC and so on.
Any Ideas?