I have been given the job to figure out how to insert County field information based on a ZipCode field in a database. The current database has a 9-digit zip code field. I have found information on 5-digit zips for all of the counties that I think are in the database and created a second table that simply has the 5-digit zips and the corresponding counties. Is there anyway to use this info to update the County field in the original database? Example: Original database ZipCode field - "17011-1234" or "17552-6789". From my other table I know that 17011 would be York County and 17522 would be Lancaster County. I am NOT a VBA expert -- have done a little bit with it. Any help would be appreciated. Thanks!