Add Line Numbers to Access Reports

Someone e-mailed me this week asking me about adding line numbers into a report in Access. Not only is it possible, but it doesn't take very long to set up. Here's how to number each item on your report sequentially:

1. In Design View, add a Text Box control to the 'Detail' section (where you'd like the numbers to show up). You'll probably want to delete the label associated with it.

2. Right-click the control, select 'Properties' (you can skip this step if your property sheet is already open). On the Properties sheet that appears, click the 'Data' tab.

3. In 'Control Source', enter an equals sign and the number one: =1

4. In 'Running Sum', choose 'Over Group' or 'Over All'. Choosing 'Over Group' means that it will start over at 1 when a new group starts. 'Over All' will keep numbering up over the entire report, regardless of grouping.

That's it!

1 comment:

  1. That was very helpful

    Thank you :)

    ReplyDelete