Hello there,

Can someone assist me with the following syntax error for the
following code:

objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id,
engagement_id, stage, iteration, description," _
& "plan_start_date, plan_end_date, actual_start_date,
actual_end_date, num_planned, num_actual," _
& "num_remain, num_passed, num_failed, num_raised,
num_open, num_closed, num_critical, num_major," _
& "num_avg, num_minor, last_update)" _
& "SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID,
MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," _
& "MATRIX_CURRENT.ITERATION_DESCRIPTION,
MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," _
& "MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END,
MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," _
& "MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED,
MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+
[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," _
& "MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+
[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " _
& "AS Closed, MATRIX_CURRENT.CRITICAL,
MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, MATRIX_CURRENT.MINOR," _
& "MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT "
& "WHERE (((MATRIX_CURRENT.ACTUAL_START)<'null') AND
((MATRIX_CURRENT.ACTUAL_END)<'null'))"

I get a compile error. Expected: line number or end of statement.
Please let me know what i'm missing. thanks.

objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id," & _
"engagement_id, stage, iteration, description," & _
"plan_start_date, plan_end_date, actual_start_date," & _
"actual_end_date, num_planned, num_actual," & _
"num_remain, num_passed, num_failed, num_raised," & _
"num_open, num_closed, num_critical, num_major," & _
"num_avg, num_minor, last_update)" & _
"SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID," & _
"MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," & _
"MATRIX_CURRENT.ITERATION_DESCRIPTION, " & _
"MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," & _
"MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END," & _
"MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," & _
"MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED," & _
"MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+" & _
"[assign_d]+[open_d]+" & _
"[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," & _
"MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+" & _
"[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " & _
"AS Closed, MATRIX_CURRENT.CRITICAL," & _
"MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, " & _
"MATRIX_CURRENT.MINOR," & _
"MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT " & _
"WHERE (((MATRIX_CURRENT.ACTUAL_START)<'null') AND" & _
"((MATRIX_CURRENT.ACTUAL_END)<'null'))"

" wrote:

Hello there,

Can someone assist me with the following syntax error for the
following code:

objDatabase.Docmd.runsql "INSERT INTO Tbl_Testing (test_id,
engagement_id, stage, iteration, description," _
& "plan_start_date, plan_end_date, actual_start_date,
actual_end_date, num_planned, num_actual," _
& "num_remain, num_passed, num_failed, num_raised,
num_open, num_closed, num_critical, num_major," _
& "num_avg, num_minor, last_update)" _
& "SELECT MATRIX_CURRENT.ID, MATRIX_CURRENT.PROJECT_ID,
MATRIX_CURRENT.ITERATION, MATRIX_CURRENT.STAGE," _
& "MATRIX_CURRENT.ITERATION_DESCRIPTION,
MATRIX_CURRENT.PLANNED_START, MATRIX_CURRENT.PLANNED_END," _
& "MATRIX_CURRENT.ACTUAL_START, MATRIX_CURRENT.ACTUAL_END,
MATRIX_CURRENT.PLANNED, MATRIX_CURRENT.ACTUAL," _
& "MATRIX_CURRENT.REMAINING, MATRIX_CURRENT.PASSED,
MATRIX_CURRENT.FAILED, MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+
[resolve_d]+[postpone_d]+[duplicate_d]+[close_d]," _
& "MATRIX_CURRENT.SUBMIT_D+[assign_d]+[open_d]+[resolve_d]+
[postpone_d]+[duplicate_d] AS [Open], MATRIX_CURRENT.CLOSE_D " _
& "AS Closed, MATRIX_CURRENT.CRITICAL,
MATRIX_CURRENT.MAJOR, MATRIX_CURRENT.AVERAGE, MATRIX_CURRENT.MINOR," _
& "MATRIX_CURRENT.UPDATE_DATE FROM MATRIX_CURRENT "
& "WHERE (((MATRIX_CURRENT.ACTUAL_START)<'null') AND
((MATRIX_CURRENT.ACTUAL_END)<'null'))"

I get a compile error. Expected: line number or end of statement.
Please let me know what i'm missing. thanks.