Get numeric value of letter

[TimTDP]

Is there a function to get the numeric value of a letter and vice versa

i.e A = 1
5 = E

Thanks

 

[gemma-the-husky]

asc(ucase(letter))-64

on the basis that the ascii value of A is 65

 

[ctags009]

conversely I suppose you could use:

chr(Number + 64)

to return the Letter

 

[gemma-the-husky]

yes

one issue is that A to Z is chars 65 to 90, but lower case letters have different ascii values.

i have no idea how access manages to sort in a case-insignificant manner

 

[Galaxiom]

i have no idea how access manages to sort in a case-insignificant manner

In VBS which is case sensitive, one typically changes the string to uppercase before sorting.