data report

[Eddy]

I have 10 records to be printed, and one of the field is a status field where I only store the value of Y, N and X only. These represent Yes, No and Canceled.
Therefore, what I would like to do is that, instead of printing the meaningless character such as Y, N and X, I would like to print the word YES, NO and CANCELED.
Somehow Data report is not producing the expected result.
for example:
NAME BIRTH DATE STATUS (actual value in table)

James Brown 01/31/1980 YES Y
Murphy Brown 03/25/1981 YES N
Charles Brown 04/10/1981 YES X

So the result is wrong for the STATUS field. Can somebody give me any advise on this matter. Thanks.

Post or Email me your SQL
?What Type Of Database