Thanks to everyone for there advice and code samples - I have it working now.

Massive help. Thanks, Jamie.

Hi Eric, thanks for the reply, can you suggest how you would do this without using T-SQL? I have taken a quick look at PIVOT but doesnt seem the most...