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,

 

 

Mel

Outcomes