Pauldohert
Something in here
- Local time
- Today, 00:54
- Joined
- Apr 6, 2004
- Messages
- 2,101
What the best way of combining fields to get a one field output for addresses
ie Address1, 2, 3, 4, 4 Town, Postcode where the 2, 3, 4 could be '' or null , so when the final field is formatted - the null ines have been removed.
At the moment all I have is long case statements which I can't see as being the best way.
Thanks
ie Address1, 2, 3, 4, 4 Town, Postcode where the 2, 3, 4 could be '' or null , so when the final field is formatted - the null ines have been removed.
At the moment all I have is long case statements which I can't see as being the best way.
Thanks