Trying to capture a very long SQL string in a VBA string

[SamT]

Break the string into logical parts and concatenate them at the end

SQLPart1 = "ABC"
SQLPart2 = "DEF"

SQLString = SQLPart1 & SQLPart2

Giving the Part variables meaningful names will help understanding the code at a later date.

sqlConnection = ?
sqlFrom = ?
sqlNamefield = ?
sqlParam1 = ?

SQLString = sqlConnection & sqlFrom & sqlNameField & sqlParam1