Create a field in table that will start with letters and autoincrement by one number?

[biz_kid1]

I am trying to make a primary key field for an auction database in Access 2010 on Windows XP SP3. I want the ID to begin with "LA" followed by auto-generated numbers that increment by one (so, LA0001, LA002, LA003 and so on). It only needs to be 4 digits long - the number of items will never be any higher than that. AuctionOrderNo only needs to be 3 digits long. And the database will only be a single user (me). I have one table (called LiveAuction) that includes the following Field Names, Data Types & Descriptions:

Field Name	Data Type	Description
ID (Primary Key)	AutoNumber	The assigned number of the live auction item.
AuctionOrderNo	Number	The order number the item will appear in the bidding list.
Description	Text	The description of the live auction item.
ItemValue	Currency	The dollar value the live auction item is valued at.
SaleAmt	Currency	The dollar value the live auction item is sold for.

How can I accomplish this please? I don't mind creating VBA to do so, but I'm not a programmer and would need my hand held through that process! Thanks in advance for your time and assistance!



~biz_kid1

[alansidman]

Look at the section in this link on Sequential numbers. Pick the one that meets your needs.

http://www.techonthenet.com/access/tables/index.php