Numbering scheme that uses 0000

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to set up a database that will assign unique numbers to records in a
table beginning at number 00001 (counting sequentially from that number
onward). I've tried unsuccessfully for 2 days now to create a numbering
scheme that will display as "00001, 00002, 00003" and so on. How do I do set
a field in a table to autonumber records in this way?
 
You don't. The way the number "looks" in the table is not relevant.

You can use the format to display the number that way in forms, reports, and
queries. Take a look at the help file for more information on using the
"format" function.

Rick B
 
Ah. Well, it's only the forms, reports, and queries that matter in this case.
Thanks for the quick response.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increment a number based on four adjoing cells 2
How to create Report showing All Product Sales by period ? 3
Serial Numbers that begin with Text 4
Auto control number 1
Excel Formula Help? 6
Add a sequence to a group of records in a query 1
How do I do a two level Vlookup? 10
New form number for each page printed 6

Back
Top