I am having a problem with a Macro that has been working up to this point. I am receiving the following message:
Run-time error '3144': Syntax error in UPDATE statement
This is the information that shows when I select Debug with CurrentDb.Execute strSQL highlighted in yellow:
strSQL = "UPDATE WeeklySummary SET "
For x = 1 To NumFields
strSQL = strSQL & "WeeklySummary." & Fields(x - 1) & " = " & rs.Fields(x - 1).Value
If x <> NumFields Then
strSQL = strSQL & ", "
End If
Next x
strSQL = strSQL & " WHERE (((WeeklySummary.WeekEnding)=" & strDate & "));"
CurrentDb.Execute strSQL
EndSub:
End Sub
__________________________________________________ _________________________________________
Sub LoadFromExcel()
End Sub
I am new to this forum and fairly new to Access so any and all help would be greatly appreciated. Thank you.