peskywinnets
Registered User.
- Local time
- Today, 01:45
- Joined
- Feb 4, 2014
- Messages
- 576
Concatenating address lines (when they are all over the place)
I sell all over the globe...& have a large database of customer addresses, constructed as follows...
ShippingName, ShippingAddressLine1,ShippingAddressLine2,ShippingAddressLine3, ShippingCity,ShippingRegion,ShippingPostcode,ShippingCountry
...in other words, each line of the customer address is separated out as individual records in my access database.
But I'd like to concatenate them, but here's the thing.....
Some addresses are quite short (only use ShippingAddressLine1 used), whereas others are quite long (they use all ShippingAddressLine1, ShippingAddressLine2 & ShippingAddressLine3)
How are you meant to cater for the diversity/permutations so that when you concatenate them, they look presentable, without gaps etc?!!!
i'm looking to run a query that takes all the individual address lines...& makes them 1 and then run a report, which will see the output of the query used to construct a proof of posting for the post office....
Mr Smith 1 Acacia Ave, Newbury, Berkshire, NB12 89T, United Kingdom
or
Mr Da Silva, 2nd floor, Room 53, Sunny View, South Island, Florianopolis, Santa Catarina 2344-023, Brazil
I sell all over the globe...& have a large database of customer addresses, constructed as follows...
ShippingName, ShippingAddressLine1,ShippingAddressLine2,ShippingAddressLine3, ShippingCity,ShippingRegion,ShippingPostcode,ShippingCountry
...in other words, each line of the customer address is separated out as individual records in my access database.
But I'd like to concatenate them, but here's the thing.....
Some addresses are quite short (only use ShippingAddressLine1 used), whereas others are quite long (they use all ShippingAddressLine1, ShippingAddressLine2 & ShippingAddressLine3)
How are you meant to cater for the diversity/permutations so that when you concatenate them, they look presentable, without gaps etc?!!!
i'm looking to run a query that takes all the individual address lines...& makes them 1 and then run a report, which will see the output of the query used to construct a proof of posting for the post office....
Mr Smith 1 Acacia Ave, Newbury, Berkshire, NB12 89T, United Kingdom
or
Mr Da Silva, 2nd floor, Room 53, Sunny View, South Island, Florianopolis, Santa Catarina 2344-023, Brazil
Last edited: