>>I have a table 'SIZE' with structure as follow:
>>
>>CODE C(10),
>>SIZE C(1),
>>SIZE_DESC C(10)
>>
>>A sample set of data is shown below:
>>
>>CODE SIZE SIZE_DESC
>>
>>001 1 S
>>001 2 M
>>001 3 L
>>002 1 M
>>002 2 L
>>003 1 XS
>>003 2 S
>>003 3 L
>>
>>
>>I need to report the data into the following way:
>>
>>CODE 1 2 3
>>
>>001 S M L
>>002 M L
>>003 XS S L
>>
>>How do I do this? If the 'SIZE_DESC' is numeric, I can do 'SELECT SUM(IIF(SIZE='1',SIZE_DESC,"") AS DESC1, .... GROUP BY CODE....'. But it is a character field, how do I do it?
>>
>>Thanks in advance.
>
>try iif(allt(str(size))="1".......

sorry, pls ignore the above msg...