MySQL help

[jeff6678 0]

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.