Share this Page URL

Chapter 6. Sorting, Filtering, and Retri... > Applying a Filter to Data in a Table - Pg. 205

Sorting, Filtering, and Retrieving Data 18. 19. 205 In the Sort row, under ExpenseType, select Not Sorted. In the Sort row for CampaignID, select Ascending. On the toolbar, click the Apply Filter button. You'll see the following set of records: 20. Close the CampaignExpenses table, and click No when you're asked to save changes to its design. Just the Steps Filter records 1. 2. Open the table containing the data you want to filter in Datasheet view. Use the filtering method that fits the kind of filter you need: · To filter records on the basis of a field value (or a series of field values), click Filter By Selection. · To filter records using criteria in one or more fields, including criteria combined with the And or the Or operator, click Filter By Form. · To create a filter with multifield criteria and to sort records by more than one field, click Advanced Filter/ Sort. 3. 4. Click Apply Filter to see the filtered records. Click Remove Filter to see the complete set of records again. Saving a Filter As a Query When you apply a filter or a series of filters to a table in Datasheet view, if you choose to save changes to the table's design when you close the table, the last filter you apply to the table is preserved. (The filter is defined in the table's Filter property, which you can see by opening the Properties dialog box for the table.) If you work with a filter regularly, but it's not always the only or the last filter you apply to a table, you can save the filter as a query in the Filter By Form window or the Advanced Filter/Sort window. Filter For