Group:  Microsoft Access ยป microsoft.public.access.gettingstarted
Thread: Sequential Numbers in Reports

Sequential Numbers in Reports
"Steve Goodrich" <stevegoodrich[ at ]btinternet.com> 12/26/2008 3:10:11 PM
Sequential Numbers in Reports.

I have a report that runs showing visitors to our building.
I would like to add a sequential number to each record of the report
starting at 1001

I have added an unbound text box to the report and set the properties as
follows:

Data Tab,
Control Source =1
Running Sum - Over all

This numbers the first record as 1 the second as 2 and so on.

Is there anyway I can set the first number as 1001, second 1002 and so on.

Thanks in advance for any advice.


Re: Sequential Numbers in Reports
"Arvin Meyer [MVP]" <arvinm[ at ]mvps.invalid> 12/26/2008 5:02:01 PM
Format([Data Tab],"\1000")
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"Steve Goodrich" <stevegoodrich[ at ]btinternet.com> wrote in message
news:mt65l.34687$PO4.15319[ at ]fe10.news.easynews.com...
[Quoted Text]
> Sequential Numbers in Reports.
>
> I have a report that runs showing visitors to our building.
> I would like to add a sequential number to each record of the report
> starting at 1001
>
> I have added an unbound text box to the report and set the properties as
> follows:
>
> Data Tab,
> Control Source =1
> Running Sum - Over all
>
> This numbers the first record as 1 the second as 2 and so on.
>
> Is there anyway I can set the first number as 1001, second 1002 and so on.
>
> Thanks in advance for any advice.
>


Home | Search | Terms | Imprint
Newsgroups Reader