[belajar-access] Re: Mohon Bantuan : Error Pada Report (Hasil DSum tidak muncul)

Assalamu'alaikum.............

selamat pagi rekan2 dan guruku semua.

Alhamdulilah masalah di atas sudah ada solusinya. Baru ketemu barusan. He he. dengan cara :

menambahkan rumus iif seperti di bawah ini :

=IIf(DSum("[BsrAnggaran]";"qLaporanPerJnsDiva_Prov_Rekap";"[KdDiva]='TP' AND [PerKabKot]='PROVINSI' AND [NmSatker]='" & [NmSatker] & "'") Is Null;0;DSum("[BsrAnggaran]";"qLaporanPerJnsDiva_Prov_Rekap";"[KdDiva]='TP' AND [PerKabKot]='PROVINSI' AND [NmSatker]='" & [NmSatker] & "'")).

terima kasih

salam,
Yana K

------------------------------------

SPAM IS PROHIBITEDYahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/belajar-access/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/belajar-access/join
(Yahoo! ID required)

<*> To change settings via email:
belajar-access-digest@yahoogroups.com
belajar-access-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
belajar-access-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/