How to convert this?

[vcavusoglu]

I have got a tinyint field in a query
field in
1
1
0
1
0
1
2
There
0-->N, 1-->K, 2-->F

Can I See this field in crystal Reports?
K
K
N
K
N
K
F
Please Help Me
Thanks

 

[MalcolmW]

Create a formula containing
If IsNull({field}) then '?'
Else If {field} = 0 then 'N'
Else If {field} = 1 then 'K'
Else If {field} = 2 then 'F'
Else '?'

Malcolm Wynden
I'm for sale at

http://wynden.net

malcolm@wynden.net