MS Access – Report – Sequential Numbering of Records

Have you ever needed to add a sequential number to a report’s rows. Well, it is surprising easy to do!

All you need to do is add a textbox into the detail section of your report and set the control’s Control Source property to ‘=1’ and then set the Running Sum property to either ‘Over Group’ or ‘Over All’ depending on what you are trying to achieve. The properties should be as shown below.

Textbox properties to setup sequential numbering in an MS Access Report
Textbox properties to setup sequential numbering in an MS Access Report

Close and save your changes and run your report. That’s it! It is that simple.

2 responses on “MS Access – Report – Sequential Numbering of Records”