Mungkin listing kode program dibawah ini bisa membantu anda...
1) SELECT A.ID,A.TglIn,A.JamIn,B.TglOut,B.JamOut
FROM Tabel_In A LEFT JOIN Tabel_Out B ON A.ID = B.ID
LEFT JOIN Tabel_Absen C ON A.ID = C.ID
WHERE A.TglIn BETWEEN '06/01/2007' AND '06/31/2007'
AND A.ID = '1234567890'
AND C.KodeAbsen = '1' ---> KodeAbsen => 1 = Normal, 2 = Absen, 3 =
Overtime(Lembur)
2) SELECT A.ID,A.TglIn,A.JamIn,B.TglOut,B.JamOut
FROM Tabel_In A LEFT JOIN Tabel_Out B ON A.ID = B.ID
LEFT JOIN Tabel_Absen C ON A.ID = C.ID
WHERE A.TglIn BETWEEN '06/01/2007' AND '06/31/2007'
AND A.ID = '1234567890'
AND C.KodeAbsen = '3' ---> KodeAbsen => 1 = Normal, 2 = Absen, 3 =
Overtime(Lembur)
----- Original Message -----
From: [EMAIL PROTECTED]
To: [email protected]
Sent: Tuesday, June 05, 2007 14:03
Subject: Re: [Programmer-VB] Lom Terjawab: Ambil Data kehadiran Karyawan
Kalau cuma mau ambil berapa hari si A masuk, berarti bisa dari table In aja
kan (asumsi kalau dia absen masuk, pasti absen keluar juga)?
Tinggal select count(ID) from In where month(TglIn)=1
Sorry, ini blom dicoba. Coba ndiri yah..
Kalau absen masuknya bisa beberapa kali, berarti harus pakai table sementara
dulu, untuk di-select distinct berdasarkan tanggal. Abis itu baru di count.
Liung's
www.apktntajd.com (Ape Kate Ente Aje Deh!)
----- Original Message -----
From: Gabriel
To: [EMAIL PROTECTED] ; [email protected] ; [EMAIL PROTECTED]
Sent: Tuesday, June 05, 2007 1:25 PM
Subject: [Programmer-VB] Lom Terjawab: Ambil Data kehadiran Karyawan
Guys.........
ndak ada yang bisa mbantu????
Dibikin mudah ajah deh.......
Dari tabel In dan Out, gwe mo ngambil berapa hari si A masuk?
Itu ajah....
Trims yo.......
--- In [EMAIL PROTECTED], Gege Nugroho
<[EMAIL PROTECTED]> wrote:
Langsung..........
Kondisi :
1. Program VB 6.0 SP 6.0
2. Crystal Report 7.0
3. MS Access
4. OS Windows XP SP1
Yang ada :
1. Tabel In (fields: ID, TglIn, JamIn)
2. Tabel Out (fileds: ID, TglOut, JamOut)
3. Tabel Absen (fielfs: ID, KodeAbsen, Ket)
Masalah :
1. Bagaimana mengambil data jumlah kehadiran 1 orang
karyawan dalam 1 bulan diluar absen, dalam satuan hari
kerja (ie : A masuk kerja 22 hari)
2. Bagaimana menghitung hari lembur diluar hari kerja
jika hari kerja 22 hari (ie: A masuk kerja 24 hari
dimana 22 hari kerja biasa dan 2 hari kerja lembur)
Trims guys........
Regards
Gege Nugroho
.
