Update Query Problem

[JimAhl]

I am having trouble doing a simple update query and not sure why it isn't working. I am trying to do an update query to update a field in a table with the results of another query. I have a select query that sums all cost items from an estimate times the markup multiplier to come up with what the total contract price is. I am then trying to use an update query that will update the contract price value to update the main estimate record, but I keep getting "Operation must use an updateable query".

Here is the update query:

UPDATE Estimate_Main INNER JOIN qryContractPriceTotal ON Estimate_Main.EstimateID = qryContractPriceTotal.EstimateID SET Estimate_Main.ContractPrice = [qryContractPriceTotal]![TotalPrice]
WHERE (((Estimate_Main.EstimateID)=[Forms]![Main_Estimate_Form]![Main_Estimate_Form_Subform].[Form]![EstimateID]));

I have searched the forums for a solution, but can't find any. Any help would be greatly appreciated.

Thanks,
Jim


I have searched

 

[Rabbie]

See this link to to see why your query may not be updateable.

 

[JimAhl]

See this link to to see why your query may not be updateable.

Thanks, but none of those causes fit. It isn't a read only problem. I can write to this table normally, just not with this update query.

 

[neileg]

In this clause : Estimate_Main.ContractPrice = [qryContractPriceTotal]![TotalPrice]
I don't think you want the ! operator. I think it should be:
Estimate_Main.ContractPrice = qryContractPriceTotal.TotalPrice