>>Thanks. How often do these zip codes change?
>
>Some zip code assignment change each year - either as a result of reassigning zip codes to split large zips up, or as a result of postal consolidation. Of the ~78K zip codes in use last uear, fewer than 50 were reassigned.
>
>However, the mapping of Zip Codes to city names shifts frequently - you may have the same zip code refer to multiple cities/towns, and these change due to redistricting and changes intown incorproations.
Ed,
You may know this but I thought I'd use your post to let folks know of something to plan for whhen dealing with ZIP codes.
One ZIP code number
can and
occassionally will be used for two city names.
I ran into this a about 9 years ago with a couple of cities in Northern California. Both had the same ZIP code.
I had to come up with a little routine that, when the user entered a ZIP code would actually do a count of the returned codes. If the count was > 1 then a pseudo list box (this was with FoxBase+ 2.10 *g*) was presented to the user.
Just something for folks to be aware of.
Best,
DD
Best,
DD
A man is no fool who gives up that which he cannot keep for that which he cannot lose.
Everything I don't understand must be easy!
The difficulty of any task is measured by the capacity of the agent performing the work.