Auto-numbering a list

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.
 
T

Tom van Stiphout

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
 
D

Douglas J. Steele

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).
 
H

Howard

Tom: Sorry it took so long to reply, but thanks for the help. This is just
what I needed.

Howard--
Howard
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top