I am sure there is a simple answer to this(well i hope so)
I am creating a report that is an invoice.
It is based on a query that selects an invoice number and shows that invoice.
However at the moment, in the report all the invoiced products are appearing on seperate pages.
I have their labels in the header section, and the controls in the detail section and i want all the products that belong to that invoice to come up in a list down the page on the same page.
Anyone know how?
I am creating a report that is an invoice.
It is based on a query that selects an invoice number and shows that invoice.
However at the moment, in the report all the invoiced products are appearing on seperate pages.
I have their labels in the header section, and the controls in the detail section and i want all the products that belong to that invoice to come up in a list down the page on the same page.
Anyone know how?