CODEWITHSUNDEEP
ms-accessms-access-2010
Mille
Mille

Reputation: 743

UPDATE query based on a saved SELECT query in Access?

Using a UPDATE query, is it possible to reference to a stored select query?

I'd like to accomplish something like this:

UPDATE ... WHERE ... IN [MY_STORED_PROCEDURE]

Upvotes: 3

Views: 118

Answers (1)

Fionnuala
Fionnuala

Reputation: 91366

Perhaps something on these lines:

UPDATE ...
WHERE ID IN (SELECT ID FROM MyStoredProc)

Depending on your set up, a join may also be possible. You can add stored queries to the query design window, but you do not always end up with an updatable query, it usually depends on your indexes.

Upvotes: 3

Related Questions