Not an update-able query error with subquery

[anoble1]

Getting this error when trying to do an update query.

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.

Ideas?

[NeoPa]

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.

[Buk1tH3d]

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...