Run-time error '3131' Syntax error in FROM clause

[stahir01]

DoCmd.RunSQL "INSERT INTO DB" & "(VT, xH, xN, Si, LT, Ont, Ser, Case, Comp, Survey_Date )" & _
"SELECT VT, xH, xN, Si, LT, SUM(Ont), Ser, Case, Comp, Date() " & _
"FROM raw_data" & _


"GROUP BY VT, xH, xN, Si, LT, Ser, Case, Comp" & _
"ORDER BY SUM(Ont) DESC;"

I tried to run this code but it gives an error

[Welshgasman]

Put it ALL into a string variable and Debug.Print that.
When you get it correct then just use

DoCmd.RunSQL YourSqlString

I am going to guess it is between the end of one line and the start of the next line at least.

Edit: I see from your other post, https://www.accessforums.net/showthr...177#post486177, that you do not seem to take the advice I have just given?