Please can you point me in the right diection. I have a table called DATA, field1 is populated from an import. what I want to do is populate field2 with data. the datain field1 starts with a 4500* and all 100* numbers below relate to the 4500* above it. I need to put the 4500* number at the side of the 100* it relates too. here is an example, I have populated field2 to show you what I mean. Thank you.
If only I had the time I would be able to help further. You basically need to write a VBA script to loop through the data, one at a time, remember the 4500 number, keep populating field 2 with it until another 4500 number is found. Rinse and repeat.