In Access 2000 queries may seem confusing at first. This free lesson offers step-by-step instructions on how to run them.
You can sort, find, and filter the results of a query just as you would other records.
When you sort a query and then close it, you are asked if you want to save the changes to the query design. If you save the changes, the query will still be sorted the next time you open it. If you choose not to save changes, the query returns to its original order.
If you filtered a query and know you want to reuse it, remember to apply the filter just before closing it. Access will ask if you want to save changes to the design of the query. If you answer Yes to save changes, the last filter is saved. When you open the form again, all records will be visible. To view your filter, click the Apply Filter button to reapply the filter. However, Access only saves the last filter you create.