I am trying to update a table using data from another table and I keep getting the following error "Operation must use a an updateable query" don't see what is wrong with what I am doing.
UPDATE [Final] SET [Final].[Mix] = (SELECT [Fix].[Mod]
where [Fix].[code] = [Final].[code] AND [Fix].[Account] = [Final].[Account] AND [Fix].Name = [Final].[Name])