>date d(8) >weight n(4) >cash n(4) >>the data in dbf is as
>01/12/2003 2345 40 >01/12/2003 4587 80 >15/01/2004 6547 20 >16/02/2004 6584 40 >20/02/2004 1475 40 >>I wnat to create a query who display following result
>Dec 6932 120 >Jan 6547 20 >Feb 8068 80>
select left(cmonth(Date),3) as MonthName, sum(weight) as WeightTotal, sum(cash) as CashTotal ; group by 1 into cursor curTotal