Add 1 to a letter

[Gina Maylone]

Ok kids, I've read a few posts, but haven't found anything to work for my application. This is an ordering system, . The current methodology is Line Item = Reference Number + Alpha character (A, B, C, D) . So I want to do a sequential function, but I need to do it with letters. I was successfully able to retrieve the last letter

getletter: DMax("[jobletter]","jobs")

and I've tried getletter+1 and of course get a type mismatch error. how do I generate the next letter?

Thank you in advance as always!
Gina

[pbaldy]

You can use the Asc() function to get the numeric value, add one to it, then use the Chr() function to get the text value of the result. You'd have to handle rolling over at "Z".

[andy49]

Create a table with two fields letter (a-z) and next letter. (B-a)

Join the fieldetter and jobletter which gives you instant access to next letter.


Sent from my iPhone using Tapatalk

[Micron]

For ascii, lower case a to z is 97 to 122; upper case is 65 to 90 (decimal). A table would be easier I think, if you had to be concerned about not using the same character twice. In that case, a yes/no field could also be used to flag the letters as having been used. Or are there only 4 letters involved and you're trying to create a list of unique combinations that start using the letter part over and over again when you get to D?

[rpeare]

How many characters long is your field?
what are your rules for this field (i.e. are caps and lower case to be considered equal or are you is your sequence a - z followed by A - Z)?
What happens at the roll over? i.e. do you go from a - z, then aa - az followed by ba - bz followed by ca - cz, etc.

This can be done pretty easily you just have to define your rules. I don't agree that a table would be the easiest way to accomplish this but it's no less valid than any other method.

[Micron]

Perhaps not, after reading your post. I was thinking there would be 26 values max.