Re: Reports 2.5

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1136911657.989502_at_jetspin.drizzle.com...
> michael.brohan_at_esb.ie wrote:
>> Hi,
>>
>> I have a query. I have a field on a summary report which is
>> abbreviated i.e. New, Aft etc.
>>
>> I want to create another field which will give the full description
>> i.e. New => New Tyres, Aft = Breakdown after hours etc.
>>
>> how is this done? I've done it before but can't remember?
>>
>> Any help appreciated
>>
>> Michael
>
> One way is with DECODE.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

decode? acchhhhh!

lookup table (code table)

++ mcs Received on Tue Jan 10 2006 - 18:45:15 CET