I am trying to update a column in a table based on values of other fields in the table. When a create a select statement this works but as soon as I turn it to an update statement the updated field has no data.
I am using Microsoft access for Office 365 MSO (16.0.12624.203 48) 32 bit
My update statement is as follows
Code:
update [Customer CL/SDM/TDM] as b inner join ( SELECT a.Customer,