Dear experts -
I have a query that is unupdatable. It has a key field called "ID".
I want to run an update query that updates a tabled called Vendor_Invoices (which has the same ID field) for any ID that is found in the unupdatable query.
Doing a simple inner join update query is not working (it's saying the query is not updatable). I'm suspecting I need a subquery.
This is the code that is giving me the unupdatable message:
UPDATE Vendor_Invoice_ExporttoExcel INNER JOIN Vendor_Invoices ON Vendor_Invoice_ExporttoExcel.ID = Vendor_Invoices.ID SET Vendor_Invoices.ExportDate = Date();