Hi there,
I have made a report that shows the details of a Supplier including address, tel number, fax number etc.
The problem I am having is that the address that is being produced by the query is made up of lots of different fields: add1, add2, add3 -> add6. Along with all the other fields displayed by the report, this takes up too much space and will not fit on one page.
Is there anyway that I can can get all the different fields for the address (add1 to add6) to appear in a single text box in the report to try and save some space?
Hope this makes sense and thanks for any help given...
I have made a report that shows the details of a Supplier including address, tel number, fax number etc.
The problem I am having is that the address that is being produced by the query is made up of lots of different fields: add1, add2, add3 -> add6. Along with all the other fields displayed by the report, this takes up too much space and will not fit on one page.
Is there anyway that I can can get all the different fields for the address (add1 to add6) to appear in a single text box in the report to try and save some space?
Hope this makes sense and thanks for any help given...