Brilliant, thanks very much.

I tweaked the query an extra little bit and made sure that there were no inner joins at all in the query, and hey presto I have...

Thanks for your post, and the link to the article.

I've tried your suggestion, but its not making much difference to the results that are being returned. I'm expecting around...

I have been asked to provide another report very similar to the one above. Its on the same table so the structure is the same.

Whereas the first report was...

Ooooh, that's brilliant! I'm great at writing loops at the best of times so this is fantastic.

Thanks v much

I've added in the top 10 but the query still needs a bit of tweaking

The query below lists the top 10 for the first branch, whereas I want it to...

Thanks - v helpful.

If I want to select just the top 10 clients in terms of costs billed/branch (top ten clients in branch 1, top ten in branch 2, etc),...

Thanks very much for your help - I'm fairly new to SQL so I didn't know there is such a thing as 'HAVING', and it does the job perfectly.

Thanks again