Microsoft Office Tutorials and References
In Depth Information
Filtering a Datasheet
5. Repeat Steps 3 and 4 to add other fields and criteria to the grid.
6. (Optional) Choose a field by which to sort the resulting table and then
choose Ascending or Descending order.
A drop-down menu appears for the Sort row in the column, containing
the field you want to sort. Access sorts the table that results from the
advanced filter in ascending or descending order, using the field listed in
the same column as the sort key.
7. When you finish creating all the criteria that you need, click the Filter
button to see the resulting table.
Access displays all the fields in the original table, but it filters the
records and displays only those that meet the criteria.
You can do several things with the resulting filtered table, including the
✦ Filter it again. Use the filter options to filter the table even more.
✦ Print it. Click the Print button.
✦ Sort it. The best way to sort is to use the Sort row in the design grid.
(Click the tab for the Filter window to display the QBE grid again.) But
you can use the Sort Ascending or Sort Descending buttons to sort the
table by the field that the cursor is in.
✦ Fix it. Click the tab for the Filter window to display the Filter window
again to fix the criteria or other information in the grid.
✦ Add data to it. Add data to the table by clicking the New Record button
and typing the data.
✦ Edit data. Edit data the same way that you do in the datasheet. When
you look at the unfiltered table, you see any changes you made in the
✦ Delete records. You can delete entire records, if you want to; click the
record you want to delete and then click the Delete Record button.
✦ Toggle between the filtered table and the full table. Clicking the Filter
button has one of two effects:
the filtered table (according to the last filter that you applied).
plays the full table.
If you want to save your advanced filter, return to Design view. After you
apply the filter, return to Design view by clicking the tab for the filter.
Rightclick the Filter tab and choose Save As Query from the contextual menu to
save the advanced filter. After the filter is saved, you can find it with the
queries in the Navigation Pane.