Need some expert help please.
I am attempting to update a table in MS Access with values from another table. I have attempted the following:
UPDATE x AS a SET a.c_days = (select b.currentdays
from Days_Current b
where b.custid = a.custid)
where a.custid in (select c.custid
from days_current c)
Where x is the table to update and days_current is a query.
The error I recieve is "Operation must use an updatable query".
Thank you in advance,
Dobe
I am attempting to update a table in MS Access with values from another table. I have attempted the following:
UPDATE x AS a SET a.c_days = (select b.currentdays
from Days_Current b
where b.custid = a.custid)
where a.custid in (select c.custid
from days_current c)
Where x is the table to update and days_current is a query.
The error I recieve is "Operation must use an updatable query".
Thank you in advance,
Dobe