Re:[belajar-access] Penggunaan Where

[Edy WIYONO]

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] AND 
          qinvoicesumremain.remainusd>0 AND 
          qinvoicesumremain.remainrp>0 AND 
          qinvoicesumremain.remainppn>0;