Hi all,

I have mytable.dbf that had 5 fields:

dateyearmonth typename cause numLoss totalloss

200601 flex aaaaa 10 1000
200602 flex aaaaa 20 2000
200603 flex aaaaa 30 3000
200604 flex aaaaa 40 4000

to get a newtable with these results with SQL statment if possible:


200601 200602 200603 200604 Grand Total

flex 10,1000 20,2000 30,3000 40,4000 100, 10000

total 10,1000 20,2000 30,3000 40,4000 100, 10000


10,20,30,40 are numloss fields with grand total of 100

1000,2000,3000,4000 are totalloss fields with grand total of 10000

Any help in coding with SQL would be appreciated

TIA