[AccessD] Geography revisited

Arthur, England, Wales, Scotland and Ireland have counties as their main
geographic unit. The street number follows the street name. Also the
postcode (your zip) comes at the end of the address (but before country if
sending from abroad), which is not true elsewhere, hence

Mr Bloggs
1 High St
Little Place
Mytown
Unpronounceableshire
UT6 7YOY


As for Singapore, were you perhaps thinking of Hong Kong?

-- Andy Lacey
http://www.minstersystems.co.uk 



> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com 
> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of 
> Arthur Fuller
> Sent: 20 March 2005 01:42
> To: Access Developers discussion and problem solving
> Subject: [AccessD] Geography revisited
> 
> 
> I don't have to solve the world's address problems, but I do have to 
> solve some of them. USA and CDN I have under control. Other 
> nations of 
> interest include basically everyone in the EU. I'm hoping for answers 
> from people either from each nation or from people with 
> knowledge of same.
> 
> 1. What corresponds to states/provinces in Ireland, England, 
> Scotland, 
> Wales, Germany, France, Netherlands, Belgium, Spain, Italy, 
> Switzerland 
> (I know it's cantons in the last, but I don't know their names).
> 
> 2. Some countries, I know, place the street name before the street 
> number. Can we define this arrangement more precisely (by nation)?
> 
> 3. Not immediately relevant, but is Singapore a city-state or part of 
> China or what?
> 
> TIA,
> Arthur
> 
> 
> -- 
> No virus found in this outgoing message.
> Checked by AVG Anti-Virus.
> Version: 7.0.308 / Virus Database: 266.7.4 - Release Date: 3/18/2005
> 
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com 
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
> 
>