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