Numbering scheme that uses 0000

R

rebecca2001

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?
 
R

Rick B

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
 
R

rebecca2001

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