Hi All,

Applogies if this is a simple one, but i'm not an every day access user.



I have an access database that's been passed records from a thiurd party application. It's basically logging records of when certain machines in a factory have been cleaned.

I want to generate a report that displays all the parameters of a clean per machine. However, I need some type of lookup on my report. The third party application can only pass an integer value that represents a machine, I want to display an actual textual description of the machine on my report for instance:

A value of 1 in the "machine" column of my table should display "Filler A"
A Value of 2 in the "machine" column of my table should display "Tank B"
etc.

How do I translate a numerical field into a text for display on a report?

Any help would be much appreciated,

Cheers,

Lee