Louis - Thank you, I am still converting your code into something that works for my situation, but I believe its exactly what I am looking for. I will let...

OP is my supervisor and posted this question on my behalf.

Transaction table - MerchantID, TransAmount

20296, 200

20331, 90.58

Corrections table - MerchantID, CorrectionAmount, CreatedOn

20296, 100.00, 6/1/16

20331, 50.00, 6/1/16

20331, 50.00, 6/5/16

We already have...