CODE worksheet function

[adamgilb]

Hi guys,

I'm trying to return the code associated with a character. Access Help tells me to use the CODE worksheet function, eg. CODE(A) returns 65, CODE(B) returns 66 etc. This works fine in Excel but what is the equivalent function in Access? In other words I want the inverse of the "chr" function.

Help!

Thanks!

 

[Snak]

Hi

It's ASC - as in ASC("B") = 66 or
ACS(LEFT([fieldname],1) = ASCII code of first char in field.

 

[adamgilb]

Thanks for that!

 

[Snak]

Welcome