Compatible Support Forums: MySQL help

Page 1 of 1

You cannot start a new topic
You cannot reply to this topic

MySQL help

#1 jeff c

stranger

Group: Members
Posts: 1
Joined: 27-June 08

Posted 27 June 2008 - 03:44 PM

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.RunSQL "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.