That looks interesting, thanks very much for your help, I will check it out.

It's 2005 Express on my dev environment and 2008 in production

Thanks. So it does seem to be something like that with a grouped statement joining back to the original table that's needed. I wondered if there was some simple alternative...