One Line Address Formula

[cantona]

Hi,

I want to create a formula or function that will display an address in one line seperated by commas. for example,

High Street,anytown,anywhere

The problem i get is that there are often blanks, which look odd. For example i get;

High Street,,anywhere

What is the easiest way of joining address fields thay may or may not be blank using comma as a seperator? The fields i have are address_line_1, address_line_2,Town, Postcode

 

[PWise]

nz(address_line_1,"") & nz(","+ address_line_2,"") & nz("," + Town,"") & nz("," + Postcode,"")

note the & and +

 

[cantona]

Hi Pwise,

Thanks for your help! thats exactly what i wanted! for future reference could you perhaps explain the use of & and + ? Ive not used + before.

Thanks!