[Year 12 IT Apps] Data type for postcode

[Mark Scott]

Mark

The article refers to Access 2003 and is copyright dated 2003

10 years out of date.

:)

Mark (the other one)
Luther College




Mark Scott
Daily Administrator
Luther
Plymouth Road
Croydon Hills Victoria 3136

Luther
Telephone (03) 9724 2000
Direct Line (03) 9724 2023
www.luther.vic.edu.au<http://www.luther.vic.edu.au/>
        [cid:luther_college_email5eb677] <http://www.luther.vic.edu.au/>

Please consider the environment before printing this email.

This email and any attachments may contain privileged and confidential information.
If you are not the intended recipient you may not distribute or reproduce this email
or attachments. If you have received this message in error please notify us by return mail.


From: itapps-bounces at edulists.com.au [mailto:itapps-bounces at edulists.com.au] On Behalf Of Mark
Sent: Tuesday, 4 June 2013 11:24 AM
To: Year 12 IT Applications Teachers' Mailing List
Subject: Re: [Year 12 IT Apps] Data type for postcode

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<mailto: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<mailto: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/42d0832b/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: luther_college_email5eb677
Type: image/png
Size: 12076 bytes
Desc: luther_college_email5eb677
Url : http://www.edulists.com.au/pipermail/itapps/attachments/20130604/42d0832b/luther_college_email5eb677-0001.png