Stewart,

I needed to apply a few minor adaptations (add a comma, reverse the percentage calculations, naming) but this works great now!

Thank you very much for supplying the sample query.

I am...

Thank you Stewart,

This looks promissing.

I'll play around with it a bit and let you know the outcome.

B.t.w.: What does CTE stand for?>

I'm always eager to learn.

Berend

Hi Stewart,

I get the part of the Count's.

But how can I combine my query and your suggestion into one resulting query which give me the DISTINCT names of the customers...

Lutz,

thank you for your primary response.

I placed the same question also on another Forum.

Here I received my answer this morning.

This means we can close this thread.

How do I do...

Lutz,

you clearly noticed that I am a newbie on this forum.

My apologies if I am not yet aware of the etiquette.

I can give you the latest version of the query...