tambah query berikut dibuntutnya.. qinvoicesumremain.remainusd>0 and qinvoicesumremain.remainrp>0 and qinvoicesumremain.remainppn>0;
-----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] Behalf Of sukarno Sent: Friday, February 29, 2008 4:26 PM To: [email protected] Subject: [belajar-access] Penggunaan Where 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
