Report problems -printing how I want issues

[tnight2060]

Hi,

I need to print a report with customers address, order details and then standard ending paragraphs - no problem, but I was having difficulty in getting the address to work so having read the forums I have now created a new quote/invoice report_1 to include a labels subreport. Address now looks perfect but I cannot now get the rest of the report to print with a sensible gap between the sections of the report and it continuously goes over 2/3 pages!

Can anyone help me out? I have come along and I am sure this is something really simple and help would be greatly appreciated.

I have attached a link to my database (I have removed some details to protect the innocent!).

many thanks,

Theresa

 

[boblarson]

A few things for you -

1. You don't need the Customers table in the recordsource of the report since all of the fields are already in the other query (qryInvoice).

2. Just by shortening up the details section it took the sample from 3 pages down to 2.

3. You should NOT be using lookup fields in your tables. Those will cause you no end of grief when using forms and reports. You should use forms for all entry and not expose the tables directly for any data entry or editing as you do not have as much control.
Read this http://www.mvps.org/access/lookupfields.htm for good information as to why lookup fields in tables are "evil."