Apologies all, I am not ignoring you and I am very grateful for your feedback it's been a manic few days!

I will read through and then post back what solution...

Thanks SQLBuddy, I am looking at the query output and I can't see any commas. How would I go about getting rid of these in my query running? I am...

Removed duplicate post!

Thanks Pouliot Philippe I am trying out the DTS package route as I think that will work better for this.

The formatting thing is a nightmare!

Thanks to all of you for your feedback/help it is appreciated!

I went with rmechaber in the end as I haven't played with cte's before and this looked challenging!

Unfortunately, my output...

Sorry to bring this one up again.

This worked perfectly, however I have a list of NULL values and have tried all combinations of things with is not NULL to try...

Jason, you made it look so easy! Thanks for this.....

Thanks Daniel that's perfect!

Hi Sturner thanks alot for this I will give it a go.....

Thank you so much for this, it worked perfectly!

Thanks both for this, I have had a read of the link.

I am looking at report layouts so that everything would be on one screen, or the team have multiple...

Ahhh skcadavre yes it is me, back again. I swear I just cannot get enough of this place and SQL 😛

And as per usual thank you so much it worked...

Hi Daniel,

Thanks for replying. I did wonder if this might be the problem so I took the floor out but a)this hasn't changed the value and b) my problem with...

Thanks both!

Daniel I went with your option, that has worked a treat!

skcadavre, thank you so much for this! I now have more reading to do on the Floor function too.