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?