Thank you very much geoff, it works.

It is quite a query, since each of the two datasets was already joined together from several tables...

And to complete the report, I have to incorporate several more queries, but for the report development side it seems the easiest solution to me.

However, I am curious if there are other approaches that can be taken. E.g. with several tables or subreports?

I know there is no one-fits-all solution, but can you tell, if the "one big query" approach is generally to prefer?

Thanks again, you helped ending a looong struggle.

Flo