Jump to content
Compatible Support Forums

jeff6678

Members
 View Profile  See their activity

  • Content count

    1

  • Joined

  • Last visited

    Never

Posts posted by jeff6678

  1. Posted

    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.

×