Korrekt syntax i modulkode

Jeg forsøger at afviklen følgende SQLforespørgsel som modulkode.

UPDATE tblAnalyzeWeeks
SET tblAnalyzeWeeks.[Akk Total Weeks] = Int(DSum("[Weeks]","tblAnalyzeWeeks","[SeasonYear] =  " & [SeasonYear] & " AND Week <= " & [Week]));

Modulkoden for samme skulle se således ud, men fejler !!

strSQL = "UPDATE tblAnalyzeWeeks "
    strSQL = strSQL & "SET tblAnalyzeWeeks.[Akk Total Weeks] = Int(DSum("[Weeks]","tblAnalyzeWeeks","[SeasonYear] =  " & [SeasonYear] & " AND Week <= " & [Week]));"
        db.Execute strSQL


Hvordan er syntaxen for :

Int(DSum("[Weeks]","tblAnalyzeWeeks","[SeasonYear] =  " & [SeasonYear] & " AND Week <= " & [Week]))

Hvad skal med / fjernes ???