Article ID: 146310 - View products that this article applies to.
This article was previously published under Q146310
This article has been archived. It is offered "as is" and will no longer be updated.
Moderate: Requires basic macro, coding, and interoperability skills.
This article describes how to create a pop-up form for setting the sort order of data in a report.
NOTE: This article explains a technique demonstrated in the sample files, RptSampl.exe (for Microsoft Access for Windows 95 version 7.0) and RptSmp97.exe (for Microsoft Access 97). For information about how to obtain these sample files, please see the following articles in the Microsoft Knowledge Base:
(https://support.microsoft.com/kb/145777/EN-US/ )ACC95: Microsoft Access Sample Reports Available in Download Center
(https://support.microsoft.com/kb/175072/EN-US/ )ACC97: Microsoft Access 97 Sample Reports Available in Download Center
This technique involves creating a pop-up form and a report in the sample database Northwind. The form enables you to choose which report fields to sort on and in which order: ascending or descending.
Creating the Report
Creating the Pop-up Form
Sorting the Report
For more information about the filter property, search the Help Index for "Filter Property," or ask the Microsoft Access 97 Office Assistant.
For more information about filter by form or filter by selection, search the Help Index for "Filter By Form" or "Filter By Selection," or ask the Microsoft Access 97 Office Assistant.