I have found a way out...
No more help needed. Thanks

O. M. G.

perhaps you could back up a bit, show us your table layouts, and explain in words what you are trying to do with that query

i for one am not going to try to figure it out -- it's a right mess

Can I advise for the future. Don't REMOVE your post after you find a solution. The whole point of the forum is that anyone/everyone who views it is supposed to learn what you are doing, offer advice, throw around ideas, and eventually come up with a solution that "should" be applicable to other circumstances. The idea is to help EVERYONE, not just yourself...

oh well ...

ytubber, please do come back if you want to try again