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