[AccessD] International Addresses

James Button jamesbutton at blueyonder.co.uk
Thu Nov 11 17:23:09 CST 2021

Belarus today, Poland tomorrow, 
Just depends where the barbed wire gets moved to !

And in the UK, there have certainly been changes of the designated local - 
As in boundary between Beckenham and Penge (in London, GB) got moved from along
the back garden boundary to along the middle of the street. 
And the government has frequently 'redefined' county boundaries.

So if it is just visiting a location - GPS - but check with the person giving
the address that the postcode is relevant to their actual location
That should, ideally put the tech to the front entrance  of the property.


-----Original Message-----
From: AccessD
<accessd-bounces+jamesbutton=blueyonder.co.uk at databaseadvisors.com> On Behalf Of
David Emerson
Sent: Thursday, November 11, 2021 10:58 PM
To: 'Access Developers discussion and problem solving'
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] International Addresses

Thanks Stuart,

In my case it is just a physical address they are storing so that
technicians know where to go for servicing.

There are different fields used for sorting and filtering locations so that
is covered separately.

Rocky's idea of having them set up the label names for the fields seems to
be the most flexible since most users will only have addresses for a single



-----Original Message-----
From: AccessD <accessd-bounces+newsgrps=dalyn.co.nz at databaseadvisors.com> On
Behalf Of Stuart McLachlan
Sent: Friday, 12 November 2021 11:11 am
To: Access Developers discussion and problem solving
<accessd at databaseadvisors.com>
Subject: Re: [AccessD] International Addresses

There are no internalonal common ways to represent addresses.

 You should be aware that household/business delivery is rare or
non-existent in many places, so depending on purpose, you may need to store
both a mailing address and a physical address which may be in different
suburbs or even towns.

What is the purpose of storing the data. Do you want to be able to
sort/group locations?

It's often best to use a single multi-line field as Address, then have
separate Town/City, State/Province, Country fields.
If you use Address1, Address2, Address3 etc  you will almoste certainly end
up with some records with Country in Address 3 and others with Country in
Address 4 or 5 etc.  making reporting an absolute PITA.

On 12 Nov 2021 at 9:45, David Emerson wrote:

> Hi Listers,
> I am writing a system that potentially could be used globally.  I am 
> looking for guidance on how to handle storing address fields.  At this 
> stage the data is just to record site addresses and probably (famous 
> last words) will not be used for mailouts as most of the sites will be 
> unattended.
> Should I just use a simple structure such as AddressLine1, 
> AddressLine2, AddressLine3, Addressline4, AddressLine5 or is there a 
> more elegant way of doing it?
> Regards
> David Emerson
> Dalyn Software Ltd
> Wellington, New Zealand

AccessD mailing list
AccessD at databaseadvisors.com
Website: http://www.databaseadvisors.com

More information about the AccessD mailing list