Run a query automatically, or wait to run the query at a later time

Microsoft Query automatically runs a query and refreshes the data in the result set each time you add a field to the Data pane or add or change criteria in the Criteria pane. If your query contains a large number of records, you might want to wait to run the query until you've finished making changes to the query.

To run a query automatically each time you add new criteria or a field, make sure that the Auto Query button is pressed in.
To wait to run a query until after you've finished adding new criteria or fields, make sure that the Auto Query button is not pressed in. When you're ready to run the query, click Query Now .