MySQL help
i am still new at SQL. . . having a problem with this do command. . rs. Open SELECT * FROM ;, CurrentProject. Connection, adOpenStatic, adLockOptimistic rc = rs. RecordCount Do While rs. EOF = False DoCmd.
i am still new at SQL... having a problem with this do command..
rs.Open "SELECT * FROM [Weekly Report - Amazon eBay1];", CurrentProject.Connection, adOpenStatic, adLockOptimistic
rc = rs.RecordCount
Do While rs.EOF = False
DoCmd.munSQL "UPDATE [Weekly Report - Amazon eBay2] SET [sales]=" & rs("Sales") & " WHERE ((Site ='" & rs("Site") & "') And ([Dept] ='N 01'))" & "'"
rs.MoveNext
Loop
rs.Close
'N 01' is text, not a vairable.
rs.Open "SELECT * FROM [Weekly Report - Amazon eBay1];", CurrentProject.Connection, adOpenStatic, adLockOptimistic
rc = rs.RecordCount
Do While rs.EOF = False
DoCmd.munSQL "UPDATE [Weekly Report - Amazon eBay2] SET [sales]=" & rs("Sales") & " WHERE ((Site ='" & rs("Site") & "') And ([Dept] ='N 01'))" & "'"
rs.MoveNext
Loop
rs.Close
'N 01' is text, not a vairable.
Participate on our website and join the conversation
This topic is archived. New comments cannot be posted and votes cannot be cast.
