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.20348) 32 bit
My update statement is as follows
Expand|Select|Wrap|Line Numbers
- update [Customer CL/SDM/TDM] as b
- inner join (
- SELECT a.Customer,
- a.[Technical Delivery Manger],
- a.[Service Delivery Manager],
- a.[Service Manager],
- a.[Customer Lead],
- a.[Organisation Owner],
- IIf(IsNull([a].[Technical Delivery Manger]),
- IIf(IsNull([a].[Service Delivery Manager]),
- IIf(IsNull([a].[Service Manager]),
- [a].[Organisation Owner],
- [a].[Service Manager]),
- [a].[Service Delivery Manager]),
- [a].[Technical Delivery Manger]) AS expr1
- FROM [Customer CL/SDM/TDM] as a) as c
- on b.customer= c.customer
- set [b].[contact owner]= c.expr1