Hi All,

I have an Access database with an AutoNumber field. Now instead of having the number starts off with 1, can I have the format to be something like: B03-001, B03-002, B03-003, and so on.

I have been looking all over the place to do something like this, but so far no luck. What I am working on is an ASP page where I input a customer purchase information. Each time I enter a new customer, the database will automatically (AutoNumber) that particular record. Now the catch is, I want that AutoNumber to start with what I want it to be, instead of 1 and increment. Please Help! If this is not the right place to ask such question, please refer me to an appropriate site. Greatly Appreciated!!! Thank you!!!
My email is [email protected] if you would like to contact me directly.

Leon

I am not sure, maybe this would help...
http://www.mvps.org/access/tables/tbl0005.htm