perintah SQL nya SELECT apotik.nama, apotik.kota, Sum(apotik.qty) AS SumOfqty, Sum(apotik.value) AS SumOfvalue FROM apotik GROUP BY apotik.nama, apotik.kota;
maman durahman wrote: > Terima kasih atas responnya. > > Pertanyaannya gini aja; gimana supaya data tersebut bisa di grouping. > Group > by Nama Apotik, yg di-SUM qty dan value. Dgn catatan alamat dan kota tetep > muncul dan formatnya tetep di query. Bukan report. > > (kalau di report sudah bisa. Cuman ya itu. saat export ke xcell dia > gak mau. > Padahal aku perlu data tsb di xcell agar bisa diedit lebih jauh). > > Send instant messages to your online friends http://au.messenger.yahoo.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/mailplus/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/mailplus/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
