Number in table to text in report

[LHWC]

I have linked tables with a numerically coded field. I want to show the text the code refers to in a report. I have several reports and underlying queries where this field appears. Currently, the reports shows "11", for instance, where I want "Oak."
I've created a table that correlates the code and text in one record. How do I get the report to switch values?
Thanks in advance.

 

[PHV]

Have you tried to join your new table in your query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244