Ah yes, that works. I was thinking you need the same columns in the SELECT list as in the GROUP BY clause, but of course you don't. Thanks Sean.

John