I'm trying to print address labels (got that bit easily enough) but I'm struggling with the empty fields. There are over 500 addresses in the system and it has Address1, Address2, Address3, Town etc.
Some of the fields are empty as the data has been input by different people over the years. The label at the moment has fields:
Is there a way to remove a field if it's blank (empty). I can create a concatenated field while will add the fields into a string but it will still show empty spaces. The only way I can think at present is to useIF and ISEMPTY() on the string. Any ideas?