By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,730 Members | 1,559 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,730 IT Pros & Developers. It's quick & easy.

Not an update-able query error with subquery

P: 229
Getting this error when trying to do an update query.
Expand|Select|Wrap|Line Numbers
  1. UPDATE tblNames INNER JOIN (qryBatteryBonus INNER JOIN tblEntrys ON (qryBatteryBonus.Month = tblEntrys.Month) AND (qryBatteryBonus.Year = tblEntrys.Year)) ON (tblNames.Salesman = qryBatteryBonus.BH_SMN) AND (tblNames.NameID = tblEntrys.Name) AND (tblNames.NameID = tblEntrys.Name) SET tblEntrys.InterstateBatteries = [qryBatteryBonus].[Test];
I have 3 tables that I have linked together. I am trying to update tblEntrys.InterstateBatteries with a field that I am querying qryBatteryBonus.Test.

3 Weeks Ago #1
Share this Question
Share on Google+
2 Replies

Expert Mod 15k+
P: 31,606
Check out Reasons for a Query to be Non-Updatable.

I suspect [qryBatteryBonus] is simply not updatable but that may not be the case. You should find it by checking through the possible optiions though.
2 Weeks Ago #2

P: 4
Anytime you have unresolved issues in your query or SQL command, the statements will be not updatable. Try not making your queries and SQL so complicated when intending to use them to update data.

You could run a query to obtain your data, then use VBA variable fields to move the data from the query to your Update command only updating the table, not a query. Just one idea. There are a thousand ways to do it I'm sure...
2 Weeks Ago #3

Post your reply

Sign in to post your reply or Sign up for a free account.