Hi,
I am creating a database with basic address information. There are 3 fields: Address 1, Address 2 and Address 3 for Street, Supplementary and Room numbers etc. I am generating a report and I was wondering if there is a way to essentially delete a field if there is no text in it. Here is an example. Two different people:
Name: John Doe
Address 1: 123 Sunnyvale Road
Address 2:
Address 3:
City/State/Zip: Brunswick, MO 63123
and
Name: Jane Doe
Address 1: XYZ Associates
Address 2: 16 West 42nd Street
Address 3: 9th Floor, Suite 200
City/State/Zip: Brunswick, MO 63123
If I set up the report to have all those fields I get the following entries:
John Doe
123 Sunnyvale Road
Brunswick, MO 63123
and
Jane Doe
XYZ Associates
16 West 42nd Street
9th Floor, Suite 200
Brunswick, MO 63123
So, it works for Jane (since she fills all fields) but not John (since he lacks info for 2 and 3). Is there a way to essentially delete unused fields so they wont take up space in the report. So john shows up like
John Doe
123 Sunnyvale Road
Brunswick, MO 63123
Thanks so much