Sorry for not including table defs, I was going to update the post with table codes as well but then I figured out a solution to my problem. Thank you...

Thanks for taking a look at it. I attached sample data from all the tables and a view of the expected results. Hopefully this will help you understand the problem...