Hi,
so if you have a table:
 Payment PID Person Amount Payment1 Payment2
     1 Alex 1 Check
   
     2 John 2 Adjustment Check
     3 Tim 3 Cash Check
     4 Mark 4 Adjustment Cash

then you make a query qPayment:
SELECT Payment.Person, Payment.Amount, Payment.Payment1 AS Payment
FROM Payment
UNION ALL SELECT Payment.Person, Payment.Amount, Payment.Payment2 AS Payment
FROM Payment;

and then one more:
TRANSFORM Sum(qPayment.Amount) AS SumOfAmount
SELECT qPayment.Person
FROM qPayment
GROUP BY qPayment.Person
PIVOT qPayment.Payment;

result will be:
 Query2 Person <> Adjustment Cash Check
     Alex 1
   
    1
     John
    2
    2
     Mark
    4 4
   
     Tim
   
    3 3

at least this is how i understand you