G
Gary L
Hi, I use variable in SQL statement, but it says "Enter Paramenter" instead.
Here is my statement:
Enbr = CStr(Month(CurM))
If Enbr <= "9" Then
Enbr = "0" + Enbr
End If
Enbr = CStr(Year(CurM)) + "-" + Enbr
DoCmd.RunSQL "Update dailyInvc_tb3 Set LogMonth = Enbr"
Any idea?
Thank you.
GL
Here is my statement:
Enbr = CStr(Month(CurM))
If Enbr <= "9" Then
Enbr = "0" + Enbr
End If
Enbr = CStr(Year(CurM)) + "-" + Enbr
DoCmd.RunSQL "Update dailyInvc_tb3 Set LogMonth = Enbr"
Any idea?
Thank you.
GL