I'm attempting to update a table after making an update query. The update works perfect when it's applied to all records. But - I need to end up updating -only- the records that come up from another SELECT query I've created.
Whenever I join the two tables, and try to run the update query though - I get pinged with this error: "Operation must use an updateable query." - Which it's all because' the select query isn't editable.
Can somebody help me out - in showing me what statement I would need to be able to pull this off?
Here's my update query string:
UPDATE dbo_computer INNER JOIN FilteredAbvNameIAVARequired ON dbo_computer.name=FilteredAbvNameIAVARequired.AbvName SET dbo_computer.group_id = 11;
And the select string I need to have the records get updated from:
SELECT AbvNameIAVARequired.AbvName, AbvNameIAVARequired.IAVANeeded
GROUP BY AbvNameIAVARequired.AbvName, AbvNameIAVARequired.IAVANeeded
HAVING (((AbvNameIAVARequired.IAVANeeded)=Forms![IAVA Dashboard]!IAVAMenu));
Thanks for always helping me out.