Printing Reports Based on Date

[Tophan]

I am trying to do a simple invoice database which will let me print all invoices for a particular week without having to print the invoices one at a time.

The Invoice report is based on qryInvoice. If I enter a criteria in the query to print by invoice number, the invoice report is showing correctly i.e., all the items per invoice are showing on one report. However, if I change the criteria in the query to print all invoices for a particular date, the report is printing all invoices on one report.

I tried grouping by Invoice number, forcing new page before/after/before & after various sections and nothing is working. If the report is not showing all the invoices on one page it is separating each line per invoice and printing on a separate page. For example, Invoice #1 has two line items but the report is separating these onto separate pages.

What am I doing wrong?

 

[Tophan]

Okay...through trial and error I managed to get the invoice details to show on one report by grouping on Invoice No and adding a total to the group footer and forcing a new page after the group footer

My next problem is how do I get the report header and footer to show on each page instead of just the first and last pages one?

 

[GinaWhipp]

You have to use the Page Header/Page Footer.