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)"