Re: Re:[belajar-access] Penggunaan Where

[sukarno]

WHERE INVOICE1.customer=[FORMS]![FCARICUSTOMER].[CCUSTOMER] AND 
          qinvoicesumremain.remainusd>0 AND 
          qinvoicesumremain.remainrp>0 AND 
          qinvoicesumremain.remainppn>0;

Mas Eddy dan Mas 
Andri, 
Terima kasih atas jawabannya,
bagaimana kalau salah satu nilainya >0 bisa tampil datanya. 

 



  ----- Original Message ----- 
  From: Edy WIYONO 
  To: belajar-access@yahoogroups.com 
  Sent: Saturday, March 01, 2008 8:01 AM
  Subject: Re:[belajar-access] Penggunaan Where



  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;