2 more cents...like Alex suggested, I'd be using a SELECT statement before the report, and joining with a colors table...
>Hello Group,
>
>If I have a table tCars and a field fiColors that contains values 0-9,
>How do I display the the word "Red" if the value in fiColors is 3.
>
>Thanks
>Jim
Steve Gibson