Jump to content
Compatible Support Forums

jeff6678

Members
 View Profile  See their activity

  • Content count

    1

  • Joined

  • Last visited

    Never

Community Reputation

0 Neutral

About jeff6678

  • Rank
    stranger
  1. jeff6678

    MySQL help

    jeff6678 posted a topic in Software

    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.
×