Cheers Dan. It works a treat.

Hi Wayne,

Thanks so much for the response which I have tested and is working. Spot on.

Appreciate your help.

Jeff, first off apologies for bland initial post as I was working on the basis someone would respond with the format of an UPDATE statement from their head without considering...

Thanks all for your contributions. I had never heard of CTE and have since looked this up on technect, very handy sql tool to have around.

I have gone with the...

Thanks Lynn,

I have ran this and it works a treat, just what I need to begin taking Excel out of the equation. Cheers.