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