Hi Jason, spot on again. I was creating the correct recordset query but when I closed the query window it kept reverting back to the previous code. I just assumed the changed were saved and written to the page. Looking closer it was throwing out one of the inner joins due to it being on its own line in the code.
Moving it down a line sorted it out immediately, wont get caught out like that again.
Cheers