ms-accessasciiletters-and-numbers

How to turn numbers to their relevant letters?

I'm creating a Microsoft Access program and I have a calculated column that looks like this:

Round([chance]/20)

I've tried adding in the ascii tab

Ascii(Round([chance]/20))

and its making a set of numbers (1-100) organised into 5 major categories (1-5), but I want the categories to be A-E instead for ease of reading I think it needs some sort of ASCII alteration but access is kind of weird and I can't seem to add the "char variable" to the calculated columns.

How do I do this?

Solution

  • You can use this expression that rounds up the category numbers:

    CategoryLetter = Chr(-Int(-[chance] / 20) + 64)