Welcome to the forum
If you create a Totals Query, you can group on Customer name and Sum the Paid amounts where Paid is "True". The SQL will look something like;
SELECT Table1.CustName, Sum(Table1.Amount) AS SumOfAmount, Table1.Paid
FROM Table1
GROUP BY Table1.CustName, Table1.Paid
HAVING...