Microsoft Office Tutorials and References
In Depth Information
Filtering a Datasheet
Follow these steps to sort and filter a table by using the Advanced Filter/Sort
1. Open the table that you want to filter in Datasheet view.
2. Click the Advanced button in the Sort & Filter group on the Home tab
of the Ribbon, and choose Advanced Filter/Sort from the drop-down
Access displays the Advanced Filter/Sort window, which has two parts,
just like Design view for queries. Notice that you now see a tab for the
table and a tab for the filter that you’re defining. The top half of the
window lists the table name and all the fields in the table.
3. Double-click the first field that you want to use to filter the table.
The field appears in the Field row of the first column of the QBE grid in
the bottom half of the window.
Instead of double-clicking a field, you can choose a field from the field
list in the QBE grid. Click the Field row of the grid to see the arrow for
the field list.
4. Click the Criteria row in the first column, and type the criteria to limit
the records you see.
If you want to see only items that cost more than $10, select the
Selling Price field as the field you want to use as your filter and then
type >10 in the Criteria row of the same column of the QBE grid.