dont worry about it, you have been great with your help. I was just wondering if you knew off the top of your head. I have used JOIN as I read INNER JOIN is not supported is some versions on a forum.
Anway thanks again Eric. Could you maybe help with my post re Search All Clients as it is quite a complex query that i need to get done pretty urgent and need some step by step instructions. I know what needs to happen if you read it but just not sure how to implement it.