Ben_Entrew
Registered User.
- Local time
- Today, 14:37
- Joined
- Dec 3, 2013
- Messages
- 177
Hi all,
I got a small problem here.
Somehow I wrote the wrong syntax it doesn't update my columns 12013 and
22013. These columns got number values.
Can someone help me please?
Thanks in advance guys.
Regards,
Ben
I got a small problem here.
Somehow I wrote the wrong syntax it doesn't update my columns 12013 and
22013. These columns got number values.
Can someone help me please?
Thanks in advance guys.
Regards,
Ben
Code:
'Vorzeichen ändern
Public Sub TEST33()
Dim i As Integer
i = 1
Do While i < 3
DoCmd.RunSQL "UPDATE Orders SET [i2013] = [i2013] *2"
i = i + 1
Loop
End Sub