DSUM Syntax conundrum

[ddelk]

I want to put this sql update statement into code but keep getting syntax errros. It works in a query but in sql I have to change all the double quotes to singles and I'm missing something somewhere.

strSql = "UPDATE TEMP SET TEMP.CUMMW = DSum('mw','dispatch_all','[totdispatch]<= " & [TotDispatch] & " and [cntrl_area]<='" & [CNTRL_AREA] & "' and [season]<='" & [SEASON] & "' and [year]<= " & [YEAR] & " and [casename] <= '" & [CaseName] & "')"
Debug.Print strSql
DoCmd.RunSQL strSql

 

[SiJP]

What's the result of the debug.print?

------------------------
Hit any User to continue

 

[PHV]

You may try either this:
strSql = "UPDATE TEMP SET TEMP.CUMMW = DSum('mw','dispatch_all','[totdispatch]<= " & [TotDispatch] & " and [cntrl_area]<=""" & [CNTRL_AREA] & """ and [season]<=""" & [SEASON] & """ and [year]<= " & [YEAR] & " and [casename] <= """ & [CaseName] & """)"
Or this:
strSql = "UPDATE TEMP SET TEMP.CUMMW = DSum('mw','dispatch_all',""[totdispatch]<= " & [TotDispatch] & " and [cntrl_area]<='" & [CNTRL_AREA] & "' and [season]<='" & [SEASON] & "' and [year]<= " & [YEAR] & " and [casename] <= '" & [CaseName] & "'"")"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886