, Please 
0
I would like to set up an address database in Access 2007.
This is normally a fairly straightforward job, however, things are never that black and white with me.
The problem is, I need to add addresses from different countries (UK, Australia and Belgium), and they use slightly different formats.
For example, in UK and Australian addresses, you write the house number first and then the street name, eg. 123 Somestreet, while, in addresses from Belgium, you do the opposite, the address there looks like Somestreet 123.
There is also a difference in how the post codes are formatted:
In the UK, the post code is made up of letters and numbers (eg. SL3 8BY) and this is written after the town name and county name, eg. Slough, Berks, SL3 8BY.
In Australia, the post code is a four digit number (eg. 3190), written after the town name, eg. Frankston, 3190, Victoria.
In Belgium, the post code is also a four digit number, but it is written in front of the town name, eg. 8400 Oostende.
My question is now, how can I set up the database so the addresses display, and especially (that is my main concern) print out correctly on envelopes, so that all addresses in the different countries come out right, something like:
UK:
Mr. Smith
12 Station Road
Slough
Berks
SL3 8BY
Australia:
Mr. Jones
198 Kangaroo Street
Frankston 3190
Victoria
Belgium:
Mr. Janssens
Prutsstraat 124
8400 Oostende
If anyone can point me into the right direction, I would be very grateful for any relevant advice.
Edited by mrdee, 09 December 2011 - 10:41 AM.
