operation must use an updatable query

gutmj

Registered User.
Local time
Today, 22:51
Joined
May 2, 2008
Messages
26
Hi,

I am executing a simple update query:

UPDATE tblMatrix INNER JOIN qrySelectMaxDate ON tblAll.SoldTo = qrySelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [qrySelectMaxDate]![MaxOfInvoiceDate];

and I am receiving an error "operation must use an updatable query".
Googled it but not of the explantation seems to be aplicable to my query.

Any thoughts?
Thanks
 
This occurs when there is a many to one relationship.
The best way to resolve is is to use a query to generate the update data table, then use the update data table to update the original table.
 
which record in tblMatrix is supposed to get updated?
 
Great, thanks a lot. Followed your advice.
 
Change qrySelectMaxDate to a make-table and run it. Call the new table tbl_SelectMaxDate

Then change your original query to UPDATE tblMatrix INNER JOIN tbl_SelectMaxDate ON tblAll.SoldTo = tbl_SelectMaxDate.SoldTo SET tblMatrix.LastInvoicedDate = [tbl_SelectMaxDate]![MaxOfInvoiceDate];

Now it should run.
 
Sorry, i wasn't clear. Thanks elliotgr, i've done that and it worked fine. Thanks for your help
 

Users who are viewing this thread

Back
Top Bottom