/* */

Monday, January 7, 2013

Re: [belajar-access] Re: query

 

Oh, kalau gitu agak susah juga ya
Sebenarnya, intinya pesan parameter value itu terjadi karena ia belum
didefinisikan, atau karena form yang dirujuk oleh criteria tidak dalam
keadaan terbuka. Begini aja, dicoba dulu set parameternya dng cara klik
Parameters di menu Design, lalu isi dengan:
[Forms]![FR_nipTotTunj]![txtBulan] -> data type Number
[Forms]![FR_nipTotTunj]![txtnip] -> data type Number (atau mungkin text,
sesuai dng di table)
lalu run kembali
Wassalaamu'alaikum Warahmatullahi Wabarakatuh,
Sofyan Efendi
----- Original Message -----
From: "oh bangsaku" son972001@yahoo.com>
To: belajar-access@yahoogroups.com>
Sent: Monday, January 07, 2013 3:58 PM
Subject: [belajar-access] Re: query

>
> 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
>> >
>> >
>> >
>>
>
>
>
>
> ------------------------------------
>
> SPAM IS PROHIBITEDYahoo! Groups Links
>
>
>
>

__._,_.___
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (33)
Recent Activity:
SPAM IS PROHIBITED
.

__,_._,___

No comments:

Post a Comment