Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Auto zip code (didn't have zip code field at first)

Status
Not open for further replies.

ericbjr2

IS-IT--Management
Jan 8, 2006
6
US
I created a table in which I should have placed a zip code field. I have about 5000 addresses that I would like to be able to query based on Zip codes. Is there a way to calculate the zip codes and populate the new zip code field automatically?
 
depends if the zip codes can be automatically calculated using data that you have access to...

you can certainly populate a field with calculated values using an update query, however it might not be possible to calculate actual zip codes...

--------------------
Procrastinate Now!
 
Well, I ended up paying $30 for a service that did it for me. I exported to an excel format, sent them the file, they added the zip codes and then I updated the database. I'm sure there is a free way to do it, but under time constraint I just paid for it.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top