code fails (syntax error)

[HS_1]

Can anyone tell me why the following code fails to execute when I am trying to input values into table, I am getting syntax error?
Thanks

Private Sub cmdPercentComplete_CWP_Click()
Dim rsSQL As DAO.Recordset


Dim rsEHTStageTally As DAO.Recordset
Dim rsEHTStagePercent As DAO.Recordset
Dim rsTotals As DAO.Recordset
Dim strsql As String


Dim intTemp, X As Integer
Dim intEHTStageTally As Integer
Dim intEHTStagePercent As Integer
Dim intTotals As Integer


Dim dblPercentComplete As Double


strsql = "INSERT INTO tblCWP_PercentComplete (EHT_EWP, "Total, Confirmed, Assembled, Reset, ReDesignRequired, DesignComplete, 3DCaddComplete, " & _
"ReCaddRequired, 2DCaddComplete, QCReviewComplete, CheckingComplete, IFCPending, IFC, PercentComplete) " & _
"SELECT '" & rsEHTStageTally.Fields("EHT_EWP") & "', " & rsEHTStageTally.Fields("Total") & ", " & _
rsEHTStageTally.Fields("Assembled") & ", " & rsEHTStageTally.Fields("Reset") & ", " & _
rsEHTStageTally.Fields("ReDesignRequired") & ", " & rsEHTStageTally.Fields("DesignComplete") & ", " & _
rsEHTStageTally.Fields("3DCaddComplete") & ", " & rsEHTStageTally.Fields("ReCaddRequired") & ", " & _
rsEHTStageTally.Fields("2DCaddComplete") & ", " & rsEHTStageTally.Fields("QCReviewComplete") & ", " & _
rsEHTStageTally.Fields("CheckingComplete") & ", " & rsEHTStageTally.Fields("IFCPending") & ", " & _
rsEHTStageTally.Fields("IFC") & ", " & Format(dblPercentComplete, "0.00") & ";"
Debug.Print strsql
CurrentDb.Execute strsql

[ranman256]

Can't you tell us WHERE the error is?

[ranman256]

Do all your string fields have delimiters?

[CJ_London]

since you debug.print the sql - can you post the resultant sql here

Also to echo Ranman's comment - can you tell us WHERE the Selected data is coming FROM?

[ssanfu]

strsql = "INSERT INTO tblCWP_PercentComplete (EHT_EWP, "Total,  Confirmed, Assembled, Reset, ReDesignRequired, DesignComplete,  3DCaddComplete, " & _

Is there a reason you have a double quote in the 2nd field ("Total")???
Remove it and the error seems to go away........ don't know if it will execute properly, though.

[Micron]

I don't use line continuation characters, so correct me if I'm wrong, but I don't believe you should be using double quotes at the breakpoint of the line, unless it's to do something like concatenate single quotes around control names with text values. So why 3DCaddComplete, " & _ as opposed to 3DCaddComplete, & _ ?

[HS_1]

Thanks guys for your help it was double quote as ssanfu pointed out.

[HS_1]

It was a double quote as ssunfu pointed out.
HS_1