>Today's Quiz. I want to maximize the number of choices I can assign to a group of records so I choose to use the alphabet through a three character field. How do I programatically increment the next assigned alphabetic character (i.e. AAA, AAB, AAC. .. AAZ then ABA, ABB, etc.)
>
>do I do this with ascii character (chr()) assignments or is there an easier way?
>
>Thanks in advance,
>
>Bill
Bill,
ASC() and CHR() will do perfectly. You can say if IF CHR(nAsciiVal)>'Z' for each digit instead of bothering with ascii values. This will make it more readable.