cara ambil filenya gimana yah...soalnya file satu dengan file lainnya...
--- In belajar-access@yahoogroups.com, Sofyan Efendi wrote:
>
> 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"
> To:
> 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 (32) |
No comments:
Post a Comment