Update ...Inner Join ... Set

[daievans]

strSummarytovault =
"UPDATE Vault " & _
"INNER JOIN File_Summary ON Vault.[Processed_File] = [File_Summary].[File] " & _
"SET [Vault].[Balance] = [File.Summary].[Total Value];"

Comes out to this ....

"UPDATE Vault INNER JOIN File_Summary ON Vault.[Processed_File] = [File_Summary].[File] SET [Vault].[Balance] = [File.Summary].[Total Value];"


File_Summary is a Query and Vault is a Table ....

The error message is attached ....

I'm befuddled, but it s bedtime ....

Thanks for your Hawk Eyes on this - i'm a bit dopey tonight

 

[jdraw]

[File.Summary].[Total Value] should be [File_Summary].[Total Value]

Here is an excellent site for debugging info.
http://www.cpearson.com/excel/DebuggingVBA.aspx