Sepertinya pembuatan rumus Tot_Tunjangan tidak bisa dibuat dalam satu query,
tapi harus di query baru.
Apakah filenya bisa disertakan? Agar bisa lebih cepat mencari errornya.
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
----- Original Message -----
From: "oh bangsaku" son972001@yahoo.com>
To: belajar-access@yahoogroups.com>
Sent: Monday, January 07, 2013 1:54 PM
Subject: [belajar-access] Re: query
> saya dah coba.....ternyata masih belum bisa....
>
> --- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
>>
>> (tunj_jabatan+tunj_istrisuami+tunj_anak+uang_makan+uang_lembur) mungkin
>> seharusnya:
>> ([tunj_jabatan]+[tunj_istrisuami]+[tunj_anak]+[uang_makan]+[uang_lembur])
>>
>> Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
>> Sofyan Efendi
>> ----- Original Message -----
>> From: "oh bangsaku"
>> To:
>> Sent: Monday, January 07, 2013 10:46 AM
>> Subject: [belajar-access] query
>>
>>
>> > 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;
>> >
>> >
>> >
>> > ------------------------------------
>> >
>> > SPAM IS PROHIBITEDYahoo! Groups Links
>> >
>> >
>> >
>>
>
>
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (31) |
No comments:
Post a Comment