Translate data in a report?

[khughes46]

I have a report that prints in two languages from the same input data. The input data is in English and the translation is into Spanish. There are two codes that must be converted into Spanish. There 4 fields that have designations for BEGINNER (B), INTERMEDIATE (I), ADVANCED (A) and ADVANCED HIGH (H). The "I" and the "A" are fine, but I must convert the letter "B" to a "P" and the letter "H" to "AS". Is there a way to do this in the report? If so, how? Thanks again.

[ranman256]

Make a translation table...
[Eng],[Esp]
A P
I B
H AS

This is the query behind the combo box.
in the combo the query has 2 fields (column count)

user picks H, but the value returns "AS". (bound column = 2)

[khughes46]

Great idea! I'm sure I will use it somewhere. I forgot to say that the letters have to be sent in both languages. That's why I wanted to do it at print time. If I have to do an interim step between the letters, so be it.