Bisa coba dibawah ini.

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

Kirim email ke