data thelp with copy and repeat o next point in a field

[octocom]

Hi there

I am new to Microsoft access and I am currently exported an advanced revelation database in CSV format to access now because advanced revelation is a multivalue pick database I needed to create a the key for the multivalue fields which I have separated the data which is NI.

Now all the data is separated in order but the NI field only shows once then its blank going down till the next NI which is the next record this is due to to the multivalue fields data that has been separated.

How can I get access to copy the NI number down into the blanks slots till it reaches the next slot and then copy that one and so on in a loop once this is done I can use this as a key field and separate the data further..

Regards

Norman

 

[octocom]

Thanks for the info pat because of the mulitvalue fields its 72000* records by how many mulitvalue entries so due to this there are 2520000 records so if anyone can help me with a simple vba routine to copy the first ni field data into the following blank entries till it reaches another entery and copy that in turn down to the next. I have done some searches but nothing for my situation im at a loss what todo next.

Regards

Norman