apa yang salah dari query dibawah ini...kok selalu minta enter parameter value????
SELECT A.bulan, p.nip, j.tj_jabatan AS tunj_jabatan, IIF(p.status='tidak menikah',0,G.tj_istrisuami) AS tunj_istri_suami, (P.jm_anak*G.tj_anak) AS tunj_anak, (A.jh_masuk*G.u_makan) AS uang_makan, (L.jam_lembur*G.ix_lembur) AS uang_lembur, (tunj_jabatan+tunj_istrisuami+tunj_anak+uang_makan+uang_lembur) AS Tot_Tunjangan FROM Pegawai AS P, Golongan AS G, Jabatan AS J, Lembur AS L, Absen AS A WHERE P.nip=L.nip and P.nip=A.nip and P.gol=G.gol and p.kd_jabatan=j.kd_jabatan and A.bulan=[Forms]![FR_nipTotTunj]![txtBulan] and P.nip=[Forms]![FR_nipTotTunj]![txtnip] ORDER BY p.nip;
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (27) |
SPAM IS PROHIBITED
.
__,_._,___
No comments:
Post a Comment