microsoft access

[monahights]

this maybe simple to many of you, but to me it is a problem.
creating a table example:
customer account #
Name
address
city
zip
but i don't want it to start from 1 with the autonumber
but rather it start from 0011,0012,0013 automatically each time you enter a new customer

 

[porkchopexpress]

You would be better off posting this in the MS Office forum forum68

 

[JoeAtWork]

There are several Access forums you could post this to.

A pretty simple way is just to create the first 10 "dummy" records and then delete them. Access doesn't "reuse" autonumbers. The next number for a new record would be 11.

However, it is usually advised not to attach special meaning to autonumbers. They are meant to provide a unique ID, and are usually hidden from the user.