<div dir="ltr">Before this thread is bought by Disney and turned into a blockbuster family entertainment feature, here is what Microsoft offers about working with postcodes/ZIP codes in Access...<div><br></div><div><a href="http://office.microsoft.com/en-au/access-help/working-with-postal-codes-in-access-HA001034544.aspx">http://office.microsoft.com/en-au/access-help/working-with-postal-codes-in-access-HA001034544.aspx</a><br>
</div><div><br></div><div><br></div><div class="gmail_extra"><br><br><div class="gmail_quote">On 3 June 2013 14:20, Andrew Shortell <span dir="ltr"><<a href="mailto:shortell@get2me.net" target="_blank">shortell@get2me.net</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div style="word-wrap:break-word">also in USA there are ZIP codes that begin with two leading zeros <div><br></div><div>
Quote: </div><div><span style="line-height:19px;font-size:13px;font-family:sans-serif">many of the lowest ZIP codes, which begin with '0', are in the </span><a href="http://en.wikipedia.org/wiki/New_England" title="New England" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">New England</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> region. Also in the '0' region are </span><a href="http://en.wikipedia.org/wiki/New_Jersey" title="New Jersey" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">New Jersey</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> (non-contiguous with the remainder of the '0' area), </span><a href="http://en.wikipedia.org/wiki/Puerto_Rico" title="Puerto Rico" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">Puerto Rico</a><span style="line-height:19px;font-size:13px;font-family:sans-serif">, the </span><a href="http://en.wikipedia.org/wiki/US_Virgin_Islands" title="US Virgin Islands" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">US Virgin Islands</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> and </span><a href="http://en.wikipedia.org/wiki/APO/FPO" title="APO/FPO" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">APO/FPO</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> military addresses for personnel stationed in </span><a href="http://en.wikipedia.org/wiki/Europe" title="Europe" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">Europe</a><span style="line-height:19px;font-size:13px;font-family:sans-serif">, </span><a href="http://en.wikipedia.org/wiki/Africa" title="Africa" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">Africa</a><span style="line-height:19px;font-size:13px;font-family:sans-serif">, </span><a href="http://en.wikipedia.org/wiki/Southwest_Asia" title="Southwest Asia" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">Southwest Asia</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> and aboard vessels based in the waters adjoining those lands; APO/FPO addresses are also used by U.S. diplomatic and consulary facilities. The lowest ZIP code is in </span><a href="http://en.wikipedia.org/wiki/Holtsville,_New_York" title="Holtsville, New York" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">Holtsville, New York</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> (00501, a ZIP code exclusively for the </span><a href="http://en.wikipedia.org/wiki/U.S._Internal_Revenue_Service" title="U.S. Internal Revenue Service" style="line-height:19px;color:rgb(11,0,128);font-size:13px;font-family:sans-serif;text-decoration:none;background-image:none" target="_blank">U.S. Internal Revenue Service</a><span style="line-height:19px;font-size:13px;font-family:sans-serif"> center there). </span></div>
<div><br></div><div>source <a href="http://en.wikipedia.org/wiki/Zip_Codes" target="_blank">http://en.wikipedia.org/wiki/Zip_Codes</a></div><div><br></div><div>Also they too have postcodes/zip codes that cross state boundaries for post office convenience</div>
<div><br></div><div>This has certainly become esoteric and thus fascinating!</div><div>Andrew </div><div><br><div>
<div style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-wrap:break-word;word-spacing:0px">
<div style="text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-wrap:break-word;word-spacing:0px">
<span style="border-collapse:separate;border-spacing:0px"><div style="word-wrap:break-word"><span style="border-spacing:0px;text-indent:0px;letter-spacing:normal;font-variant:normal;text-align:-webkit-auto;font-style:normal;font-weight:normal;line-height:normal;border-collapse:separate;text-transform:none;font-size:medium;white-space:normal;font-family:Helvetica;word-spacing:0px"><div style="word-wrap:break-word">
<div>Andrew Shortell</div><div>Educator</div><div>CRC Melton</div><div><br></div><div><br></div><div><a href="mailto:shortell@get2me.net" target="_blank">shortell@get2me.net</a> (This List)</div><div>@acsbear8 (twitter)</div>
</div></span><a href="http://www.vitta.org.au/" target="_blank">VITTA</a> CoM Member</div></span><br></div><br></div></div></div></div></blockquote></div><div class="gmail_extra"><br></div><snip></div><div class="gmail_extra">
<br><div dir="ltr">--<div>Mark Kelly</div><div>mark AT vceit DOT com</div><div><a href="http://vceit.com" target="_blank">http://vceit.com</a></div><div><br></div></div>
</div></div>