|
This following tip is (as is often the case) the answer to one of the questions I have received in the past. I have made the assumption that if one person asks the question then it is likely others also wish to know the answer to the question.
Question
How do I get serial line numbers to appear on a report in Access?
Answer
To add serial (sequential) numbers for a report:
Add an unbound text box to the design section of the report;
Then, open the text box properties (right click and select properties);
Set the following under the ‘Data’ tab:
Control source '=1'
Running Sum = 'Over Group’ if you wish to count the records in each group
OR
Running Sum = 'Over All' if you wish to display consecutive numbers for all the records.
Do you like this tip? Subscribe to my weekly Newsletter to receive tips
weekly via email.
Click Here to subscribe.
|
