jackmac

Remove blank address fields?

Discussion created by jackmac on Nov 24, 2015
Latest reply on Nov 24, 2015 by skywillmott

Hi all,

 

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:

 

Name

Add1

Add2

Add3

Town

Postcode

 

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?

 

TIA

 

Jackmac

Outcomes