Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    43

    Unanswered: What is wrong with this command?

    Having trouble with this Update table. I have two tables one is the final table for this information the other is information pulled from a file. Now what is suppose to happen is the new information is suppose to be put into the final table where that information goes to that persons name. But the UPDATE script keeps saying their is an error. Now I have tried this in many differnt ways any help is appreciated.


    DoCmd.RunSQL "UPDATE Test SET(October_Minutes),(October)=SELECT [Minutes],[Charges]FROM Qry WHERE (User_Name FROM Test) = (User_Name FROM Qry)"

    Thanks,
    Bill

  2. #2
    Join Date
    Oct 2003
    Posts
    43

    Forgot to metion

    This is in Access 2000.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that's the weirdest sql i've seen in a while -- where'd it come from?

    here, try this:
    Code:
    UPDATE Test 
    INNER JOIN Qry
     ON Test.User_Name       = Qry.User_Name
    SET Test.October_Minutes = Qry.[Minutes]
      , Test.October         = Qry.[Charges]
    rudy
    http://r937.com/

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •