Hi Paul.

Nothing jumps out at me, but that query is really hard to read. I'd probably rewrite it a bit and see if it doesn't help highlight the problem.

Thanks for the response. I finally got it working using a derived table in the query.