AnsweredAssumed Answered

Joining Text Fields - calculation

Question asked by melclift on Nov 21, 2016
Latest reply on Nov 21, 2016 by melclift

Hi everyone,


This probably has a really simple answer.


I have 4 fields for names -  vendor name, vendor surname, vendor first name2, vendor surname2


I have worked out how to join the fields based on the assumption that there is data in each field:


Vendor Name & " " &Vendor Surname & " & " & Vendor firstname2 & " " & Vendor Surname2


Giving the result:

John Smith & Fred Jones


My question is - if I don't have a second vendor, ie, no Fred Jones, how do I stop the "&" from showing in the resulting field?


Many thanks,