Hi everyone,
I have an access report that is a recreation of a letter. My table contains each person's mailing address with a separate field for each address line.
My problem is if I place each address line fields on the report underneath each other, there will be blank lines because not everyone has multiple address lines.
Ex: DAVID GEORGE
123 EAST WESTBROOK
APT #32
CITY, STATE ZIP
But the next record could look like this because they don't have more than one address line:
DAVID STILLS
123 HOLDEN DR
CITY, STATE ZIP
I don't want the blank line on Holden. Is there any way to do this?