SQL String need to use underscore for continuation of line of code

[ItsMe]

My SQL works fine with the underscores I have in place now. Sometimes my SELECT statement gets real long and I can't seem to figure out how to continue the SELECT statement on an additional line of code. I am not great with SQL and it takes me time to figure out quotes vs. apostrophe enclosed quotes, etc. while using different data types. So I can not tell if I am doing something wrong or VBA just does not allow for this.

And how do I paste text within the body of my post so it appears in its own window in the body?


strWhere = ""

strWhere = "SELECT [qryMasterSum].[MoveDate], [qryMasterSum].[PickCity], [qryMasterSum].[DelCity], [qryMasterSum].[TruckDurringMove], [qryMasterSum].[EquipLicNum],[qryMasterSum].[Import]" _


& "FROM [qryMasterSum]" _
& "WHERE (qryMasterSum.DriverID)=" & glngDriverId & " AND ((qryMasterSum.MoveDate)>=#" & gdtDate & "#)AND (((qryMasterSum.MoveDate) <=#" & gdtDateEnd & "#))" _
& "ORDER BY [MoveDate];"

[June7]

Need spaces in the string so parts don't run together when compiled. Here's how I do it:

strWhere = "SELECT MoveDate, PickCity, DelCity, TruckDurringMove, EquipLicNum, Import " & _
"FROM qryMasterSum " & _
"WHERE DriverID=" & glngDriverId & " AND MoveDate Between #" & gdtDate & "# And #" & gdtDateEnd & "# " & _
"ORDER BY MoveDate;"

You can go to the Advanced post editor and use tools to enclose text within CODE or QUOTE tags or you can type them. Use the tools first to learn the tag structure.

[ItsMe]

Need spaces in the string so parts don't run together when compiled.

Thank you June. I think what you are referring to happened in my attempt to paste my code into the post. I pulled that example out of an existing DB that functions well. I see what you did by naming the fields by eliminating brackets and the query name. That definitely shortened the SELECT part of the statement. I will try that for sure.

Is there a way to use the underscore smack in the middle of the SELECT statement. For example using more quotes and an ampersand together with an underscore.

[June7]

Sure, break it anywhere you want.

[ItsMe]

I used to try and try to break my SQL in the middle of a SELECT or WHERE statement. I could never get right and just gave up on it. I have been writing code 1000 pixels wide for ever.

So I just focused on counting characters and spaces like you mentioned and presto, it worked. Plus, I didn't realize I could do without the brackets.

Thanks June.

[June7]

The brackets would be needed if names have spaces or special characters/punctuation (underscore is exception) or are reserved words. The query name qualifier would be needed if pulling fields with same name from several sources in a JOIN sql.