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

On Thu, 31 Dec 2009 05:43:01 -0800, Howard
<(E-Mail Removed)> wrote:

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



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

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



--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)



"Howard" <(E-Mail Removed)> wrote in message
news:6841B177-21E4-4E45-A300-(E-Mail Removed)...
>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.
> --
> Howard

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

Howard--
Howard


"Tom van Stiphout" wrote:

> On Thu, 31 Dec 2009 05:43:01 -0800, Howard
> <(E-Mail Removed)> wrote:
>
> 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
>
>
>
> >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.
> .
>