Hi Jason,
I have tried all your suggestions and used navicat query builder and have come to the conclusion I need help to put together this recordset as I have spent the last 2 weeks trying to get it to work and got nowhere. Would you please confirm whether my only alternative left is to pay webassist to help me resolve this?