• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Hour 15. Power Query Techniques > Applying Advanced Filters

Applying Advanced Filters

Using advanced filters, you can further refine the data that appears in a query result. Here are the steps involved:

1.
Open (in Datasheet view) the query or table whose data you want to filter.

2.
Select Records | Filter | Advanced Filter/Sort. The filter design grid appears.

3.
Add to the design grid the fields on which you want to filter.

4.
For each field on the grid, enter the value or expression that you want to use as a filter in the Criteria cell for the fields you have included.

5.
Click Apply Filter or select Filter | Apply Filter/Sort. Access applies the filter that you created.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint