R
Rick Campbell
I link to a database that has a city field and a zip code field. I run
statistics on the city field, but the zip field is more accurrate. In other
words, many times the city field is wrong. I would like to make a new table
that would change the city fields to reflect the city that the zip code
belongs to.
Can someone give me an idea of how to do this? I also need to keep all the
other fields in the database intact.
TIA
Rick
statistics on the city field, but the zip field is more accurrate. In other
words, many times the city field is wrong. I would like to make a new table
that would change the city fields to reflect the city that the zip code
belongs to.
Can someone give me an idea of how to do this? I also need to keep all the
other fields in the database intact.
TIA
Rick