Automatically create numbers

[W-technologies]

Hi Guys,

sorry for the bad title, I'm not sure how to word what I want.

im creating a product table and I want to Automatically create the product ID numbers instead of having to manually write them all in - example below

so the product ID's will be

WT-00001 to WT-20000



i don't want to have to write the 20,000 before I start entering products and categories.

does that make sense?

thanks

[JoeM]

One easy way would be to create the list in Excel, then Import into Access.

Otherwise, you could probably use VBA and Recordsets with loops to generate the list directly in Access.

[qa12dx]

make table - product_ID - autonumber , product_desc - text

now if your form/qry/report use this formating;
"WT - " & IIf(Len([Product_ID])=1,"0000" & [product_id],IIf(Len([Product_ID])=2,"000" & [product_id],IIf(Len([Product_ID])=3,"00" & [product_id],IIf(Len([Product_ID])=4,"0" & [product_id],[product_id]))))

included a sample db if i am not able to explain properly. shown use in both form and query.