hi
can you please help me by showing me the code.. or at least telling me what to do

I need to show in a cross-tab table a list of rooms of hotel (rows) columns would be days... I need to show whether that room is occupied or not

cross tab shows

0 for vacant
1 for reserved
2 for occupied

I need to show V instead of 0 and so on, since it is more legible...

can you help me with the formula?

thanks a lot