Auto-numbering a list

  • Thread starter Thread starter Howard
  • Start date Start date
H

Howard

I have a data base which prints a report based upon starting dates. When I
print the report, I want the list to print a number to the left of each name
which starts with the number "1" and goes to the end of the list. The list
may change, but I still want the numbering to work the same. Is there
anything in Access which can do this, or do I need to write some code?
Thanks for the help.
 
On Thu, 31 Dec 2009 05:43:01 -0800, Howard

Yes, there is a simple and elegant solution. Create a textbox to hold
the value. Set its ControlSource property to "= 1". Set its RunningSum
property to True. Done.

-Tom.
Microsoft Access MVP
 
Add an unbound text box to your report.

Set its ControlSource to =1 and its RunningSum property to Over All (or Over
Group, depending on how your report is set up).
 
Tom: Sorry it took so long to reply, but thanks for the help. This is just
what I needed.

Howard--
Howard
 
Back
Top