Skip to content

Interactive Report Sorting and Filtering in Access 2007

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:

Right-click here to download pictures. To help protect your privacy, Outlook prevented automatic download of this picture from the Internet.
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:

Right-click here to download pictures. To help protect your privacy, Outlook prevented automatic download of this picture from the Internet.
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

About this author