I currently have a make table query which contains the formula ADDRESSLINE1: StrConv([Address],3) & (Chr(13)+Chr(10)+StrConv([Address2],3)) so that it combined Address and Address2 into one cell, making sure to convert it into capitals and put Address2 onto a new line. This works fine however when there is nothing in Address2 it still puts in an enter. Therefore, when it is imported into a CRM system and mail merges are created it will look like this:
Mr Smith
20 Smith Lane
London
SW19 8DF
Is there a way to remove the extra enter line if the Address2 is blank?
Thanks (very new to this so not really sure what I'm doing!)