Many thanks for your help everyone.

Best wishes
Jon

Thanks Gail, but I'm not sure how to achieve that.
I've been doing this (which I thought might work), but I still get multiple rows per ContactID

SELECT ContactID,...

That's perfect, thank you 🙂

Fantastic - thank you very much.

Hi there

Yes, CompanyName.

I tried to make it easier to explain when I was doing it before, but I seem to have made things more confusing, my apologies.

Best wishes

Jon

Hi all

Thanks for your continued help (I know that it's probably like pulling teeth!).

Attached are two text files showing the relevant table scripts as requested (I'm unable to post them...

Hi both

Sorry, I didn't realise that (newbie!), but thanks for explaining it. I've now produced the CREATE TABLE scripts and have posted them below. As you'll see the scripts contain...

Hi both

Sorry, I didn't realise that (newbie!), but thanks for explaining it. I've now produced the CREATE TABLE scripts and have posted them below. As you'll see the scripts contain...

Hi John

Thanks for your reply. The database already exists, so I'm unable to post what would be CREATE TABLE scripts (I think this is what you mean?). However, I've shown...

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...