Access 2007 has a new Report view which implements interactive sorting and filtering.
Access Archon #158
Access 2007 has a new Report view for reports, which implements a long-requested feature: interactive sorting and filtering. To use this feature, select the Report view for a report:
Figure A. The new Report view in Access 2007
In the report, right-click on a value in a column to get a menu of filtering and sorting choices:
Figure B. Interactive sorting and filtering choices for an Access 2007 report
This is a great new feature of Access 2007, that may eliminate the need for an input form or parameter queries when you need to sort or filter a report in different ways.
References
The code in the sample database does not need any special references.
Supporting Files
The zip file containing this article, in Word format, plus the supporting file(s), may be downloaded from the Access Archon page of my Web site. It is accarch158.zip, which is the last entry in the table of Access Archon columns for Access Watch.
Document Name |
Document Type |
Place in |
Modified Northwind.accdb |
Access 2007 database |
Wherever you want |