Hi again,

Thanks to the help I've been given so far I am nearly there. I have the data I need in one table which I've recreated in the ddl...

Thanks vladan for your time and trouble.

I have corrected the issues you've raised with the ddl :blush: and have attached it again.

Your SQL is so much simpler than my first...

Hi rbarryyoung,

I asked a similar question as an aside on one of my posts so this helped me too. Thanks.

Hi vik.ram.79

Hope you don't mind me stepping on...