Hi Guys,
I am working on a database containing approx. 300,000 records. Some of which have been assigned same ID's. I want to go through the column id and for each duplicate value i want to add sub id in the next column. eg.
Member_ID Sub_ID 76w3322 1 72y6860 1 72y6860 2 67g0230 1 36p7832 1 36p7832 2 36p7832 3 45h6741 1
The intent is to uniquely identify every record in the database. IS it possible through SQL queries or help me with Macro code.
My idea is:
x= first column value;
i=1;
While(End of the column){
offset to next row cell;
if(x==current row value){
i=i+1;
add value of i to next column cell in the same row
}
else{
i=1;
add value of 1 to next column cell in the same row
}
}
Help me guys with the code.......