>>>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.
>
That's actually very frequent, especially in areas of low population density, where a zip code covers hundreds of square miles (parts of Alaska come to mind, not to mention APO/FPO addresses) and in urban areas where a number of small townships have become absorbed into a larger entity (there's one zip code in the New Haven area that's referred to by 4 different names.)
>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