Hello,
I was trying to format addresses for a report, but am having difficulty on one part. I need to be able to omit the comma between "city" and "state" if there is no "city" listed as happens sometimes with the foreign addresses. I tried the following but it did not work:
=Format_Address([Add 1],[Add 2],[Add 3],[City],[State],[Zip]) & IIf(IsNull([City]),Null,",")
Any advice would be greatly appreciated. Thanks very much.
I was trying to format addresses for a report, but am having difficulty on one part. I need to be able to omit the comma between "city" and "state" if there is no "city" listed as happens sometimes with the foreign addresses. I tried the following but it did not work:
=Format_Address([Add 1],[Add 2],[Add 3],[City],[State],[Zip]) & IIf(IsNull([City]),Null,",")
Any advice would be greatly appreciated. Thanks very much.