Thanks Dick, I eventually managed to do it the way you said. The query
was a bit complicated so I had to go over it a few times to ensure the
syntax was correct but it works now.