Dear all, Mohon pencerahan dari SQL berikut bagaimana cara penggunaan where untuk remainusd,remainrp,remainppn kalau nilainya diatas 0 saja yang akan ditampilkan.
SELECT INVOICE1.invoice_no, INVOICE1.date, INVOICE1.amount_usd, INVOICE1.amount_rp, INVOICE1.ppn, INVOICE1.wo_no, INVOICE1.customer, INVOICE1.project, INVOICE1.term, [date]+[term] AS duedate1, INVOICE1.pic, INVOICE1.po, INVOICE1.attn, Now()-[DUEDATE1] AS OVERDUE, qinvoicesumremain.remainusd, qinvoicesumremain.remainrp, qinvoicesumremain.remainppn FROM qinvoicesumremain INNER JOIN INVOICE1 ON qinvoicesumremain.invoice_no = INVOICE1.invoice_no WHERE (((INVOICE1.customer)=[FORMS]![FCARICUSTOMER].[CCUSTOMER])); Terima kasih Sukarno
<<burung terbang.gif>>
