Ben_Entrew
Registered User.
- Local time
- Yesterday, 22:05
- Joined
- Dec 3, 2013
- Messages
- 177
Hi all,
I get a syntax error with the following code:
Can anyone help me out here?
Thanks in advance.
Regards,
Ben
I get a syntax error with the following code:
Code:
Public Sub TEST()
DoCmd.RunSQL "Update TEST_TNS Set Total_Net_Sales = "Total_Net_Sales" + DSum("Total_Net_Sales","TEST_TNS","Division = 'Common'") " & _
" Where Division IN ('MC','AK')"
End Sub
Thanks in advance.
Regards,
Ben