[eluser]Nathan Pitman (Nine Four)[/eluser]
Thanks Brad, in the end I took a different approach and got at the same result with a sub query in the select. I've not used having before but I'll have to read up a bit on that. Thanks for taking the time to reply!