SAMS
Nov 15th, 1999, 04:39 PM
hi guys, u use sum to add up numeric but how do u add up string(DIAGDESC). I have this multiple rows of records which are being group into one record. But I cannot add up the fields which contain string into one field group into one record.
The code :
select SUM(DIAGDESC), Format(sum(bmk),'######0.00') as total from export_ar GROUP BY CLAIMNO, Vend_ID, fromdatesvc, dept, hpcode, invoice_no, MEM_ID, MEM_NAME, daterecd order by CLAIMNO asc
What other command can i use?? Thks
The code :
select SUM(DIAGDESC), Format(sum(bmk),'######0.00') as total from export_ar GROUP BY CLAIMNO, Vend_ID, fromdatesvc, dept, hpcode, invoice_no, MEM_ID, MEM_NAME, daterecd order by CLAIMNO asc
What other command can i use?? Thks