ContributionsMost RecentMost LikesSolutionsRe: Can I concatenate two fields into one when one field is blank?I created the new field and used the formula you provided and it works exactly as I was hoping it would! Thank you for all your help Austin! ------------------------------ Kristin Bombaci ------------------------------ Re: Can I concatenate two fields into one when one field is blank?Thank you for your response Austin. I should clarify that I am trying to do this in a report, not in a form so the advice above would not apply. Do have a suggestion on a formula I can use in a report? ------------------------------ Kristin Bombaci ------------------------------ 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]="",[MERRecord - MERS Analyst]&""&[PORecord - PO Analyst]) I want the value in the PORecord - PO Analyst field to populate in the MERRecord - MERS Analyst field when the MER Record - MERS Analyst field is blank. ------------------------------ Kristin Bombaci ------------------------------