Thank you the most amazing, incredible SQL query. I cannot begin to describe how much this query assisted me. I have one request though please.

I now need to run a query that outputs payments against age bucket.

eg. MemberID, Full payment, 0days Payment, 30days Payment etc. etc.....

Can you modify so that the query produces the aged report & we then run perhaps another SQL to show how each payment was "allocated".

Thanking you kindly.