Hi Scott

Many thanks for your response, and great suggestion. I have managed to get round the issue (although not perfect) by pulling the week number and data first into a temp table then adding the months the weeks belong to after in a separate query. Not great but it will have to do for now.

Thanks again.

Adam,