I'm still working on an old app. I have a select statement to find the total of all credit card payments for all credit cards. The statement that I currently have is:
SELECT DISTINCTROW Sum(tblCreditCardPayment.[CP Amount]) AS CCPmt, tblCreditCardPayment.[CC Account]
FROM tblCreditCardPayment
GROUP BY tblCreditCardPayment.[CC Account];
This works fine, but I now want to find the total of all "active" credit cards. The active flag is in tblCreditAccounts.CCActive.
Any ideas on how I can accomplish this?