It does indeed. I suspected it might have to be written into the report itself, but I was just curious as to whether or not it was something that could...

Exactly as you posted it earlier, albeit with the correct names inserted in place of Item A, B etc. Works like a charm.

As an aside, the code using PIVOT also works...

Thanks Guys,

Working on the CASE statement already, and it's absolutely flying through them. Cheers for the help!

Scott

Hi Chris,

Did a bit of digging into this - it looks like it would have been perfect for what I needed, but it kept falling over with syntax errors. Problem...

Yes, using 2005 - anything you can suggest would be great!

Thanks,

Scott