Help with building a expression FieldA to FieldB 1

[lcdhead]

I have a table with a numeric field named TransType. The field stores a number 1 - 6. I would like to have another field in the database that breaks this down as:
if TransType = 1 then NEWFIELD = "Blue" else
if TransType = 2 then NEWFIELD = "Red" else
if TransType = 3 then NEWFIELD = "Yellow" else etc...

Should I be trying to create a new field in Access to accomplish this? My actual results are displayed on an ASP page over the Intranet. Returning a column "TransType" with numbers in it is not to meaningful to my viewers.

Thanks for any help.

 

[PHV]

Have a look at the Choose function or create a lookup table.

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