Hi Lutz
Thank you for your reply. I have re-looked at the tables in my query and it seems as though I was missing a table which held all the relevant information.
So, on this occasion we can put it down to "newbie error".
Many thanks for your time.
Best wishes
Jon