select kode_brg,nama_brg,sum(jml) from tablenya group by kode_brg,nama_brg
Thanks Ronald Irawan http://www.Foodinvestment.com/?id=ronald_delgeano Jakarta matrixsoke waluyooke <[EMAIL PROTECTED]> Sent by: [email protected] 20/02/2007 11:24 Please respond to [email protected] To [email protected] cc Subject [Programmer-VB] SUM of Record Aku punya data Koneksi Adodc1 dengan Field sbb: kode_brg Nama_brg Jml 01 aaa 10 01 aaa 5 01 aaa 5 02 bbb 7 02 bbb 3 02 bbb 2 03 ccc 3 03 ccc 3 di inginkan menjadi record yang double langsung di hapus 01 aaa 20 02 bbb 12 03 ccc 6 memakai perintah sum caranya gimana ya..? Send instant messages to your online friends http://uk.messenger.yahoo.com
