Update records in a field - Use query?

[mdo]

Hello,

I constantly have to import an excel file to Access. In this file it has a field called Region. This field has numbers in it such as 3000 then several blanks than 3095 then several blanks, etc. I would like to replace the blanks with the same number that it follows such as 3000 should all be filled in before the 3095 then 3095 should all be filled before the next number, etc. Can this be done in a query? If so, how? If VB code, how? Your help is greatly appreciated.

Thanks!

 

[jeremie_ingram]

I had a very similar issue, what I did was import the information, then run code to manipulate that data in the exact manner you stated (fill in the blanks w/ the previous #)

The thread is loacted here:
http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=43336

Or Search form my ID jeremie_ingram And look for a posting of mine titled Record Data Manipulation.

The code provided by Fornatian worked perfectly and took only a few seconds over several thousand records.