need to convert numbers to unique text

B

BrandonBassett

Joined
Jan 17, 2008
Messages
1
Reaction score
0
So, for the database I'm working on there is a field (CONDCODE) which can be a number from 1 through 6. In a report, I want the number to be display as a unique text line instead. For instance, instead on '1' I want to see 'Alive', instead of '2' I want to see 'Fresh', etc. I've been trying to research how to do this, but am not having much luck. Any help would be appreciated!
 
Back
Top