I am building a report which will pull data from a form. There are a lot of fields that will be listed and separated by commas.
Basically the box will look like this:
= IIf(IsNull([1]),"",[1] & ", ") & IIf(IsNull([2]),"",[2] & ", ") & IIf(IsNull([3]),"",[3] & ", ")
I need the last comma of that statement to be replaced with a period regardless of what data shows up and doesn't. What code would do this?
Thank you for your help.