EternalMyrtle
I'm still alive
- Local time
- Today, 13:38
- Joined
- May 10, 2013
- Messages
- 533
Why can't I ever get these to work properly? I want to use them to ignore null fields so that I won't get the punctuation but it isn't working.
Here is what I have but the commas still show up:
=IIf([Status]=1,(+[MailBoxOrPOBox]) & (+", "+([CompanyLocID].[Column](2))) & (+" ,"+([CompanyLocID].[Column](3))),"")
is there a better way than trying to use these + signs??
Thank you!!
Here is what I have but the commas still show up:
=IIf([Status]=1,(+[MailBoxOrPOBox]) & (+", "+([CompanyLocID].[Column](2))) & (+" ,"+([CompanyLocID].[Column](3))),"")
is there a better way than trying to use these + signs??
Thank you!!