Look at using Common Table Expressions (CTE)

Here is a rough sample based on your details

Thank you for the pointer to CTE and the example.

I have only looked at CTE briefly once before (for representing tree structures), so it will take me some time to do some reading and to dissect your example.

BR Mike