Restore the full result set by removing criteria

Microsoft Query

Show All

Restore the full result set by removing criteria

If your query contains many records, you can save time by waiting to refresh the result set until you've removed all the criteria. To wait to refresh the result set, make sure the Auto Query button is not pressed in.

  1. In the Criteria pane, click the heading of the column that contains the criteria you want to delete.
  2. Press DELETE.

    Repeat steps 1 and 2 for each set of criteria you want to remove.

    To remove all criteria at one time, click Remove All Criteria on the Criteria menu.

Note   If the Auto Query button is not pressed in, you must click Query Now to restore the full result set.