How do I convert numbers to letters on my chart in MS Access. (please see screenshot). The values come in as Letters. I convert the values in the query to numbers using Asc(string) to get the values on the y-axis.
The problem is is that users do not understand that 66 equals a 'B'. I need to somehow convert that letter back from a number so the y-axis shows Letters again.
Any suggestions? Can you provide example of how to do this?