SQL Code does not fit in one line in Excel VBA, automatically moves down one line

Hello,

I have a big SQL Code which does not fit in one line in Excel VBA. When I try to insert it, the Microsoft Basic Visual Editor automatically moves down by one line the code and put an "" at the end of the first line.
Example, lets say here is my SQL code, which is big, but I will put a sample:
sSQL = "SELECT ... "

When I try to add the rest of the code it automatically moves down to below line, does not allow me to continue, as the "" is automatically inserted at the end. Is there a way to prevent this from happening? Maybe concatenating the SQL code? how should I do that?

Here is my code, if needed, but I do not think it will be needed:

Please Login or Register  to view this content.

JosephP I tried your first option it did not work when I put WHERE in a different line. It says there is no WHERE statement.... Now, I will try your second option.

TMShucks I have not treid that, how can I do that, please?

I am really sorry JosephP I see where is the issue. There was no space between the WHERE and its above line. Thank you so much!!!!!