Very long SQL statement - line continuation

[DanAuber]

Hi there,

I have a HUGE sql statement which I'm entering into a Module as follows:

docmd.runsql ("Select etc etc etc;")

The statement will not fit on one line so I'm trying to do the following:

docmd.runsql ("Select etc etc _
etc etc etc;")


However Access will not accept it

Can anyone help me get over this ?

Thanks in advance

 

[JerryKlmns]

Dim strSQL AS String
'Building one line at a time
strSQL = "SELECT "
strSQL = strSQL & "Field_1, "
strSQL = strSQL & "Field_2, "
...
strSQL = strSQL & "Field_N, "
'Building with line continuation
strSQL = strSQL & "FROM yourTableNameHere " & _
"WHERE Field_1 = 'LaLaLa'"
'Just don't forget any space needed between continuations

 

[Remou]

You may get a message "too many line continuation characters" with a very long string. If you do, use smaller pieces.

strSQL= "Blah _"
strSQL=strSQL & "More Blah _