I'm having a little trouble knowing what to search for to find an answer, so I'm hoping someone here will be able to help. For a novice like myself, it is difficult, but for the experienced, this should be a piece of cake.
On a report I have the following code to concatenate two fields.
However, most records will have a NULL value in the second field so I would like to know how to eliminate the comma between the fields if this second field is NULL.
On a report I have the following code to concatenate two fields.
Code:
=Trim([ContactAddress] & ", " & [ContactAddress2])