Newbie question on generating reports

[nadeem]

Hello,

I want to generate a simple report in MS-Access 2010. It will only have three fields, two of which will come directly from the tables.

The third field is a numeric code that will also come from the tables, but in the report I do not want to display this numeric code, instead its text description. For instance, if the code coming from the table is '1', I want to display 'Pending' in the report.

How do I achieve this on-the-fly translation in my report?

Thanks,
Nadeem

[pbaldy]

Typically you would have a table with two fields: the numeric value and the text value. Your report would be based on a query that joined your main table (which presumably contains the numeric value) with this table, allowing you to have the text value on your report.