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