How to Print an Incremental Line Number in an Access Report
Microsoft Office Access is a database management program provided in the Office suite. Access stores information then allows query and manipulation of the data. The immense flexibility available with Access makes it a strong application with multiple programming options. One such activity includes structuring reports. An incremental line number on a report simply starts at number one and continues counting each line until the last line prints. Working with an Access database requires practice. The product makes it time well spent.
Other People Are Reading
Instructions
-
-
1
Open the Access database on your computer.
-
2
Set your screen to Design view by clicking on "Design" at the top of the window. This view allows you to edit your screens and reports.
-
-
3
Click on "Reports" located on the left side of your screen. This will open the Reports menu.
-
4
Navigate to the report and double-click to open it.
-
5
Add a calculated text box to the "Detail" section of your report. Click on the text box button located on the Toolbox bar at the top of the screen. If the toolbar is not showing, click on "Window" at the top of the screen and open it.
-
6
Double-click on the new text box to display the property sheet.
-
7
Move your pointer to the "Control Source" property and type in "=1."
-
8
Use the "Tab" key on your keyboard to navigate to the "Sum" property and set it to "Over All." Click on "OK" to close the window. Your report will now print with line numbers.
-
1
Tips & Warnings
A sample report with incremental line numbers can be found in the Northwind database provided with the software. Look for the "Sales by Year."
