Thank you Ray and Mark for your ideas. The query I'm actually using is quite complex but you both have given me some ideas on how to structure my procedure.

Best...