Dear rekan-rekan programmer,
Saya minta bantuannya nih :-) saya memiliki table data sbb: USER TGL KODE KETERANGAN JAM CM KETERANGAN AN 17/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 18/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 23/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 23/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 1 0 - AN 31/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 2 0 KONFIRMASI PESERTA AN 03/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 - AN 23/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 1 0 - AN 31/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 KONFIRMASI PESERTA AN 03/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 18/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 21/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 29/01/2008 200804 ISO 22000:2005 26-27 FEB '08 4 0 - Bagaimana query-ya saat di export ke excel, maka bisa di jumlahkan field jam berdasarkan pengelompokkan field kode? Mohon bantuannya dan terima kasih. Contoh layout: AN 16/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 2 0 PROMOSI VIA EMAIL AN 16/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 2 0 PROMOSI VIA EMAIL AN 17/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 18/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 23/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 1 0 - AN 200801 WAREHOUSE MANAGEMENT 12-13 FEB '08 42 0 AN 23/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 1 0 - AN 31/01/2008 200802 MANAGING TRAINING FUNCTION 12-13 FEB '08 2 0 KONFIRMASI PESERTA AN 200801 MANAGING TRAINING FUNCTION 12-13 FEB '08 5 0 AN 03/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 - AN 23/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 FOLLOW UP KIRIM BROSUR AN 28/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 1 0 - AN 31/01/2008 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 2 0 KONFIRMASI PESERTA AN 200803 BUSINESS PROCESS IMPROVEMENT 13-14 FEB '08 7 0 AN 03/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 18/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 21/01/2008 200804 ISO 22000:2005 26-27 FEB '08 2 0 - AN 29/01/2008 200804 ISO 22000:2005 26-27 FEB '08 4 0 - AN 200804 ISO 22000:2005 26-27 FEB '08 10 0 Salam, Didi [Non-text portions of this message have been removed]
