ADODB.Connection Closed due to .commandtext changing from original

Hello everyone

I have quite a large sql query which somehow changes when I put it into my commandtext.

The query normally works, however when I run a debug.print I notice it separates some of the command onto a new line which is where it breaks

Any thoughts on how to stop it starting a new line

this is the debug.print cmd.commandtext - in red is where the new line begins but shouldn't

Please Login or Register  to view this content.

This is my total code

Please Login or Register  to view this content.