cheers guys that seems to do it!

Really appreciate all this help guys.  Unfortunately i can't really post the table structure as the foreign keys are handled by the front end (very odd i know ... and...

Thanks for the info and quick reply, however using the "Union all" command didn't speed up the return of the results set ... the problem continues.