What is wrong with this command?

bwood415 · #1 (**permalink**) 10-17-03, 15:52

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****nSQL "UPDATE Test SET(October_Minutes),(October)=SELECT [Minutes],[Charges]FROM Qry WHERE (User_Name FROM Test) = (User_Name FROM Qry)"

Thanks,
Bill

bwood415 · #2 (**permalink**) 10-17-03, 16:17

This is in Access 2000.

r937 · #3 (**permalink**) 10-17-03, 20:50

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/

Internet Services

Web Development

Digital Marketing

Consumer Tech