You can use a query with UNION ALL.
SELECT < first set of fields > FROM mytable
UNION ALL
SELECT < second set of fields > FROM mytable
ORDER BY question
>
>
>my table have fields as
>
>qustion countof1 pctof2 countof2 pctof2......countof17 pctof17
>q1 6 2.1 5 1.9 8 2.5
>q2 4 1.6 9 3.2 .......................
>.
>.
>q17 14 9.4 4 1.6 9 3.2
>
>at the new table or cursor
>qustion countof1 countof2 ......countof17
>q1 6 5 8
> 2.1 1.9 2.5
>q2 4 9 ..................
> 1.6 3.2 ................
>.
>.
>q17 14 4 9
> 9.4 1.6 3.2
>
>
>
>
>thanks
--sb--
