You can also right-click the field and select Clear. Access clears or removes all of the filters. In the Sort and Filter group, click Advanced and select Clear All Filters from the drop-down menu.In Layout View, click the Home tab in the Ribbon.For example, if you select Date Filters, other options appear such as Between.īelow is the menu as it appears if a user right-clicks on data in a Date Entered field: From the menu, select the desired options.The options in the menu will appear for date fields. For example, if you would like to filter a Date Entered field, right-click on a date entered and a context sensitive menu will appear. Right-click the data you want to filter.For example, if you select Number Filters, other options appear such as Between.īelow is the menu as it appears if a user right-clicks on data in an Actual Sales field: The options in the menu will appear for number fields. For example, if you would like to filter an Actual Sales field, right-click on any actual sales data and a context sensitive menu will appear. If you are opening a report, right-click on the report in the Navigation Pane and choose Layout View. If you are in Design View, right-click the tab or title bar of the report and choose Layout View. View the report in Report or Layout View.The report will appear in its filtered state.īelow is the menu as it appears if a user right-clicks on a city in a City field: Filter number fields in Layout View For example, if you select Text Filters, other options appear such as Begins with. The options in the menu will appear based on the type of field. For example, if you would like to filter a City field, right-click on any city and a context sensitive menu will appear. Recommended article: 10 Timesaving Shortcuts in Microsoft Accessĭo you want to learn more about Microsoft Access? Check out our virtual classroom or live classroom Access courses > Filter text fields in Layout View
You can filter reports created in desktop databases with Microsoft Access using this method but not in a Microsoft Access app. In this article, we’re going to use Layout View. You can also apply filters in Report View (which is a view that doesn’t offer the same formatting functionality as Layout View). In newer versions of Microsoft Access, you can use Layout View to quickly filter data in a report without having to create a new query to use as the source for the report.
How to Quickly Filter Microsoft Access Report Data in Layout Viewīy Avantix Learning Team | Updated April 9, 2021Īpplies to: Microsoft ® Access ® 2010, 2013, 2016, 2019 and 365 (Windows)