Re: [belajar-access] Rumus Denda

Dear bang harryjewell,

SELECT P.TglJT, P.Pajak, P.Keterangan, P.TglDue,
IIf([tgldue]>[tglJT],[pajak]*2/100,0) AS Denda
FROM Table1 AS P;

atau

SELECT P.TglJT, P.Pajak, P.Keterangan, P.TglDue,
IIf([Keterangan]="Belum Lunas",[pajak]*2/100,0) AS Denda
FROM Table1 AS P;

Best Regards,
AccessWizards

Pada tanggal 20/01/11, Jewell <harryjewell@yahoo.com> menulis:
> Dear para suhu access
>
> Pembayaran Pajak PBB paling lambat tanggal 30 September tiap tahunnya.
> Pembayaran setelahnya dikenakan denda 2% per bulan bagi wajib pajak yang
> dalam kolom Keterangan "BELUM LUNAS", sementara "LUNAS"=0.
> Bagaimana rumusnya agar kolom denda terisi otomatis dan terupdate setiap
> bulannya?
> Terima kasih.
>
>

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

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/