I can't believe it!!! I've been struggling with this for days and the moment I post a question I fiqure it out 5 min later. The expression can be modified...

Thanks everyone for your input. I did try originally having the IS NOT NULL condition part of the join clause using an INNER and LEFT join but the result were...