I have the following in my query to concatenate my addresses.
However, it doesn't give the correct results when there are two consecutive blanks.
Has anybody come across this before ?
I'm a bit puzzled as to how to get this to work.
As always your time and comments are very much appreciated.
Code:
Address: IIf(IsNull([Address_Line_1]), "", [Address_Line_1] & " " & Chr(13) & Chr(10)) & IIf(IsNull([Address_Line_2]), "", [Address_Line_2] & " "& Chr(13) & Chr(10)) & IIf(IsNull([Address_Line_3]), "", [Address_Line_3] & " " & Chr(13) & Chr(10)) & IIf(IsNull([Address_Line_4]), "", [Address_Line_4] & " " & Chr(13) & Chr(10)) & IIf(IsNull([TownCity]), "", [TownCity])
However, it doesn't give the correct results when there are two consecutive blanks.
Has anybody come across this before ?
I'm a bit puzzled as to how to get this to work.
As always your time and comments are very much appreciated.