>I need to sum 2 fields within a table. THis table contains the following needed fields:
>
>claims.dbf
>CONO,INNO,LCH_TOT,SUPR_TOT
>
>The first 2 cono and inno combine(cono+'-'+inno) to make the agreement number. I need to SUM lch_tot, supr_tot, and lch_tot + spr_tot for each agreement number and then total the whole bunch. ANy suggestions? Also where can I found some good material to educate myself on SELECT-SQL?
>
>Shane Gilbert

Try foolowing:
Select cono+"-"+inno as argumnum, sum(lch_tot) as lchsum, ;
sum(supr_tot) as suprsum, sum(lch_tot+supr_tot) as allsum ;
Group by 1
VFP manual itself is the best source.