select "s40" AS descript, SUM(s40) AS tot
UNION ALL ;
select "s20" AS descript, SUM(s20) AS tot ;
INTO CURSOR crsResult

>Hey Guys,
>
>Need help in my inventory program.
>
>The situation is like this:
>
>I have a table (TABLE 1) which contains fields (item (c), s40(n), s20(n)) how can I get the records in TABLE 1 particularly fields item and either of s40 or s20 which ever i selected then append all of them into lets say TABLE 2 and at the same time get total of either s40 or s20.
>
>example: (TABLE 1)

________________________________
>Item          s40           s20
>--------------------------------
>paper          3             2
>bottle         12            25
>_______________________________
>               15            27
>
>(TABLE 2)
>
>_______________________________
>s40          15
>-------------------------------
>s20          27