I hoped to simplify the question when asking and probably should have posted the query in its entirety and the result set. This is my first post so I am certainly learning how to do it the right way.

Thank you all. I appreciate your time. Back to the drawing board for me and with your suggestions I will be in good shape.

Cheers