Thanks Robert and Tim for your answers... (muchly appreciated)

Yes of course Robert it's not the QUERY returning the wrong answer, its
my query not doing what I had planned.

And you're spot on with your analysis and by removing the aggregates as
you suggested, helped me see exactly where I was going wrong. I worked a
solution based on using SUM for the TransTotal and not for the
TotalNights into a memory table and then selecting / aggregate the data
from there.

Cheers Guys!

Robert

>Heresy. SQL always returns the "correct number". It's the question that is
>worng.


Nice one

Roy Lambert