• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

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

0
asarda
Asked:
asarda
  • 2
1 Solution
 
fridomCommented:
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


return?

0
 
asardaAuthor Commented:
Returns around 20 values, it will vary everytime
0
 
Rey Obrero (Capricorn1)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

0
 
asardaAuthor Commented:
That worked. Thanks
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now