Hello,
This is my last "omit comma" question I promise...but would anyone know how to omit the comma if the city field is blank, in the label wizard as it returns an =Trim expression. I tried adding the following but it did not work:
=Trim([City] & ", " & [State] & " " & [Zip]) & IIf(IsNull([City]),Null,"," & [State]" " & [Zip])
Thanks for your help and advice, it is much appreciated.
Lily
This is my last "omit comma" question I promise...but would anyone know how to omit the comma if the city field is blank, in the label wizard as it returns an =Trim expression. I tried adding the following but it did not work:
=Trim([City] & ", " & [State] & " " & [Zip]) & IIf(IsNull([City]),Null,"," & [State]" " & [Zip])
Thanks for your help and advice, it is much appreciated.
Lily