Graeme Edwards wrote:

[...]

> It does open up a whole new area of using a subselect within a group by
> query that I hadn't considered before.
>
>
>
> Graeme
>
>
>
>
> Obviously you havent tried this in sql editor.
> It works perfectly.
>

Could you please change your quoting style so that we can distinguish
between your text and the quoted text?
Thanks....

--
Magnus