I would like to know whether the following routine is possible.
I have a table of addresses:-
There are occasions when the address is so short that Address 3 (A3) is not required even though the country field is filled in.
I also have a report which picks all four addresses. However, given the above, when I print the report, there is a blank gap in the address3 .
I was wondering whether itis possible to avoid that.
the report instead of looking like:-