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.
- In the Criteria pane, click the heading of the column that contains the criteria you want to delete.
- 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.