Autonumber question

[Edgarr8]

Hi,

I have a table with about 700 records that i need in a number sequence of 4 digits ex.0000 i would really like to use the auto number function to create the numbers but I don't know how to do it.

If its not possible to do it in the table i would like to do it in the query, is there an expression that i can have it convert any number to a 4 digit number?

 

[Galaxiom]

Copy the table structure ony to a new table and add the autonumber field.
Make an append query to add the records to the new table.

To make a number into a four digit string: Format({expression}, "0000")

 

[boblarson]

And actually you don't even need to use a separate table. You can just go into design view and add a new field with Autonumber. As long as there isn't another autonumber field in that table you can do this. Then when you open the table the numbers will magically be there.

 

[boblarson]

Oh, I did forget to mention. Numbers are not stored as multiple digits unless they are multiple digits. As Galaxiom mentions you can FORMAT them wherever you use them but they are not stored that way as numbers.

 

[Edgarr8]

Thank you!

I got it!