Assigning a unique number to a unique text

[wdbouk]

Hi ,

I have a 1,500,000 ID such as 6543AE , 6543AF, 456AV etc.... I am looking for the unique IDs in order to assign them a unique number in a new column such as 1 for 6543AE, 2 for 6543AF, 3 for 456AV. is it possible to do so using Access?
Thx
W

 

[PHV]

Have you tried to simply add an AutoNumber column ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[wdbouk]

I looked at the all options available and i wasn't able to locate the Autocolumn. is it ok if i asked u to elaborate in this matter?
thx

 

[lespaul]

you would have to modify the table by adding an additional field: right click on the table and select 'Design View' add a new field and make it an Autonumber type.


Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design