ACC: Displaying First and Last Record Per Page in Page Footer

MORE INFORMATION

1. Open the sample database Northwind.mdb, and create the following macro:
   

         Macro Name    Action
         ----------------------
         SetFirstRec   SetValue
   
         SetFirstRec Actions
         --------------------------------------------------
         SetValue
         Item: [Reports]![Index Report]![FirstRec]
         Expression: [Reports]![Index Report]![IdxFirstRec]
   						

2. Start the Report Wizard and create a report based on the Customers table. In the "Which fields do you want on your report" box, select the following fields, and then click Next:
   

         CompanyName
         ContactName
         City
         Region
         Country
   						

3. In the "Do you want to add any grouping levels" box, click Next. In the "What sort order do you want for your records" box, select CompanyName in the first combo box.
4. Click Finish to display the new report in Print Preview.
5. On the File menu, click SaveAs/Export. Enter Index Report as the report name and click OK.
6. On the View menu, click Report Design, and add the following text box to the page header:
   

         Text box:
         Name: IdxFirstRec
         ControlSource: [CompanyName]
         Visible: No
   						

7. Add the following two text boxes to the Page Footer:
   

         Text box:
         Name: FirstRec
   
         Text box:
         Name: LastRec
         ControlSource: [CompanyName]
   						

8. Set the Page Header OnFormat property to the SetFirstRec Macro, and save and close the report.
9. Open the report in Print Preview. Note that the first and last company names on the page are displayed in the page footer. Go to the next page of the report. Note that the first and last company names for that page are now displayed in the page footer.