Brilliant, thanks very much.

I tweaked the query an extra little bit and made sure that there were no inner joins at all in the query, and hey presto I have a complete list.

Its the first time I've ever had need to use an outer join - I will re-read the article you posted the link to for next time.

Thanks once again.