Can I concatenate two fields into one when one field is blank?
I need to merge two field into one field if one field is blank. I have developed the below formula based on advice from this page but it has not been successful. If([MERRecord - MERS Analyst]="",[M...