Trying to Update a Table in MS Access 2003

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]
from  [Fix]
where [Fix].[code] = [Final].[code] AND  [Fix].[Account] = [Final].[Account] AND [Fix].Name = [Final].[Name])

Open in new window

Who is Participating?
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try this

Update [Final]
Inner join [Fix] On
Fix].[code] = [Final].[code] AND  [Fix].[Account] = [Final].[Account] AND [Fix].Name = [Final].[Name]
set [Final].[Mix]=[Fix].[Mod]

Open in new window

How many values does:
(SELECT [Fix].[Mod]
from  [Fix]
where [Fix].
 = [Final].[code] AND  [Fix].[Account] = [Final].[Account] AND [Fix].Name = [Final].[Name])

Open in new window


asardaAuthor Commented:
Returns around 20 values, it will vary everytime
asardaAuthor Commented:
That worked. Thanks
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.