For information on the difference between a static and dynamic query, refer to What are dynamic and static queries, when are they refreshed, and when to use them?.

  1. Open the query
  2. Select Tools, Query Options from the menu bar
  3. On the General tab change the format from dynamic to static or vice versa
  4. Click OK
  5. Click Save

Note: The format of a merged query is always static and cannot be changed.