Title may not make much sense, so if you have come this far then stick with me.
I want to combine two fields for a form and probably on a couple of reports as well. I want a comma to show if both fields contain a value, however, if only one of the fields has a value and the other does not, then I do not want a comma.
For example, there are college athletes that have played some international ball before playing collegiality.
Lets say I have a field called 'College' and another as 'International Club.'
Obviously, I know I can display this as Team: [College] & ", " & [International Club]. However, by doing this, for any player with just International experience and no College, their field will display as ", International Club."
To sum things up, I just want a comma to show when it is necessary.