In MS Access a Query Q2 can be so simple as SELECT * FROM Q1 (or largely complicated).

Since Q1 can be another Query instead of a Table, the question arises.

Does running Query Q2 trigger Query Q1 or does it use some cached data if Q1 has been run previously?

This can be very important if Query Q1 has side effects like INSERT or DELETE.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.