Spell out category code letters in a report.

[IzzyKap]

I have a database in which I had used codes for different job categories (e.g. A, V, I, etc.). I would like to spell out the categories (e.g. Active, Vacant, Inactive, etc.) in a report as opposed to merely showing the code letters. I have used a query to generate the report showing number of jobs under each category. What would be the simplest way to spell out the categories? Thanks in advance.

[pbaldy]

Typically you'd have a table with fields for the code and the description. Your report would be based on a query that joined the two tables together, allowing you to include the description field.