How to print numbers from 00001 to 10,000 onto labels

[Benny Kay]

How do you design a database to print running numbers from 1 to 10,000 onto labels? Just like printing customers' names, I want to print lets say numbers from 00001 to 10,000 onto labels, so that I can paste them on in-coming documents. I cannot enter 10,000 records in a table and then use it as a record source in the report to print them on labels, there must be a easy way? Pleas help?

 

[MStef]

You don't need to enter 10000 records in the table.
Let the Query (Make table, or Append) to do this.

 

[Benny Kay]

Thanks MStef for your tip. But how do you do it? Can you please teach me how? Thanks.

 

[MStef]

Hello Benny!

Look at "DemoQry10000A2000.mdb"
Open Form1 and try.

 

[Benny Kay]

Thanks a million MStef. It works beautifully. Thanks again.