If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Sequential Numbers in Reports
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. |
#2
|
|||
|
|||
Sequential Numbers in Reports
Format([Data Tab],"\1000")
-- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "Steve Goodrich" wrote in message . .. 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. |
Thread Tools | |
Display Modes | |
|
|