Hi Perry ---
Try this:
SELECT SUM(field2) AS sumf2,SUM(Field3) AS sumf3, (..et al) ;
FROM mytable INTO CURSOR summarytable
INSERT INTO mytable (field2,field3....) VALUES (summarytable.field2,summarytable.field3,...)
>
>One question though. I'm trying to get the sum of each field to append as the last record in the table. Here's what i have:
>
>select xtab
>go bottom
>append blank in xtab nomenu
>for lnCnt = 2 to fCount() && 2nd field is the 1st numeric field
> lcFieldName = field(lnCnt)
> replace &lcFieldname with sum(lcFieldName)
>endfor
>
>should I add the table name lcFieldName = 'myTable.'+Field(lnCnt)??
>
>TIAA
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05