My SOQL statement so far looks like this
SELECT Designated_Bank__c, Deposit_Date__c, Actual_Payment_Amount__c, Name FROM npe01__OppPayment__c WHERE Deposit_Date__c= 2023-03-30 AND Designated_Bank__c= '218 Wintrust Checking 5906'
What I want is a single line with the Designated Bank, total for actual payment amount, and a string of PMT values that make up the payment amount.
Thank you for helping.