ACC: How to Create a Top 10 ReportLast reviewed: October 24, 1997Article ID: Q109319 |
The information in this article applies to:
SUMMARYNovice: Requires knowledge of the user interface on single-user computers. This article describes a method for creating a Top 10 report, which is a report that lists the first 10 records, based on the report's sort order. NOTE: In Microsoft Access 2.0, 7.0 and 97, you can base a report on a top values query. For more information about TopValues, search for "TopValues Property" using the Microsoft Access Help Index. 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:
ARTICLE-ID: Q145777 TITLE : ACC95: Microsoft Access Sample Reports Available on MSL ARTICLE-ID: Q175072 TITLE : ACC97: Microsoft Access 97 Sample Reports Available on MSL MORE INFORMATIONThe following example demonstrates how to create a Top 10 report using a calculated control's RunningSum property to provide a dynamic counter for each record. A macro called from the report's OnFormat property then cancels the formatting of records whose counter falls outside the range you want to print:
Notes
REFERENCESFor more information about sorting data in reports, search for "sorting data," and then "Sort records in a report" using the Microsoft Access 97 Help Index.
|
Additional query words: ten
© 1998 Microsoft Corporation. All rights reserved. Terms of Use. |