>>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.
Sorry, add 'From Claims', please!
Edward Pikman
Independent Consultant