Waduh, maaf sebelumnya berantakan....
Contoh tabel yang ada ssat ini:
USER TGL KODE KETERANGAN
KETERANGAN JAM CM
AN 17/01/2008 200801 WAREHOUSE MANAGEMENT -
3 -
AN 18/01/2008 200801 WAREHOUSE MANAGEMENT -
2 -
AN 18/01/2008 200802 MANAGING TRAINING
- 4 -
AN 19/01/2008 200802 MANAGING TRAINING
- 2
AN 19/01/2008 200803 BUSINESS PROCESS
- 5
AN 20/01/2008 200805 SERVICE EXCELLENCE
- 4
Tabel yang ingin di tampilkan di Excel:
USER TGL KODE KETERANGAN
KETERANGAN JAM CM
AN 17/01/2008 200801 WAREHOUSE MANAGEMENT -
3 -
AN 18/01/2008 200801 WAREHOUSE MANAGEMENT -
2 -
TOTAL
5
AN 18/01/2008 200802 MANAGING TRAINING
- 4 -
AN 19/01/2008 200802 MANAGING TRAINING
- 2
TOTAL
6
AN 19/01/2008 200803 BUSINESS PROCESS
- 5
TOTAL
5
AN 20/01/2008 200805 SERVICE EXCELLENCE
- 4
TOTAL
4
Mohon bantuannya dan terima kasih.
_____
From: [email protected] [mailto:[EMAIL PROTECTED]
On Behalf Of Didi
Sent: 21 Februari 2008 9:51
To: [email protected]
Subject: [indoprog-vb] Tanya penjumlahan
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]
[Non-text portions of this message have been removed]
