easy one

[nfo1212]

How do you write a sql statement on multiple lines? The _ continuer doesn't seem to work for them.

Many Thanks

[chrisjk]

in what?

[Hack]

Dim SQL As String

SQL = "SELECT yada FROM yada "
SQL = SQL & " WHERE yabba = 'dabba'
SQL = SQL & " AND ......

etc.

[blindlizard]

sSQL = "Select *"
ssql = ssql & " From Table"

[Hack]

I saw chrisjk comment after I posted mine.

My suggestion implies the creation of a string which is executed in VB via the .Execute method of whatever type of environment you are using, i.e., ADO, DAO

[nfo1212]

That's what I needed to know. Thanks!

[scostell]

strSQL = "SELECT one, two, three " & _
               "FROM table1 " & _
               "WHERE one = 1"

that'll do it

[gulliver]

Try this:

sSQL = "SELECT * FROM " & _
"TableName WHERE " & _
"Blah blah blah!"

[nfo1212]

Oh, that's even better actually. Thanks again.