[Year 12 IT Apps] Data type for postcode

[Mark]

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...

http://office.microsoft.com/en-au/access-help/working-with-postal-codes-in-access-HA001034544.aspx




On 3 June 2013 14:20, Andrew Shortell <shortell at get2me.net> wrote:

> also in USA there are ZIP codes that begin with two leading zeros
>
> Quote:
> many of the lowest ZIP codes, which begin with '0', are in the New England<http://en.wikipedia.org/wiki/New_England> region.
> Also in the '0' region are New Jersey<http://en.wikipedia.org/wiki/New_Jersey> (non-contiguous
> with the remainder of the '0' area), Puerto Rico<http://en.wikipedia.org/wiki/Puerto_Rico>,
> the US Virgin Islands <http://en.wikipedia.org/wiki/US_Virgin_Islands>
>  and APO/FPO <http://en.wikipedia.org/wiki/APO/FPO> military addresses
> for personnel stationed in Europe <http://en.wikipedia.org/wiki/Europe>,
> Africa <http://en.wikipedia.org/wiki/Africa>, Southwest Asia<http://en.wikipedia.org/wiki/Southwest_Asia> 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 Holtsville, New York<http://en.wikipedia.org/wiki/Holtsville,_New_York> (00501,
> a ZIP code exclusively for the U.S. Internal Revenue Service<http://en.wikipedia.org/wiki/U.S._Internal_Revenue_Service> center
> there).
>
> source http://en.wikipedia.org/wiki/Zip_Codes
>
> Also they too have postcodes/zip codes that cross state boundaries for
> post office convenience
>
> This has certainly become esoteric and thus fascinating!
> Andrew
>
>   Andrew Shortell
> Educator
> CRC Melton
>
>
> shortell at get2me.net (This List)
> @acsbear8 (twitter)
> VITTA <http://www.vitta.org.au/> CoM Member
>
>
>
<snip>

--
Mark Kelly
mark AT vceit DOT com
http://vceit.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/itapps/attachments/20130604/719e7d8e/attachment.html