Report has redundant pages 1

[PSchubert]

Hello all, and thanks in advance...
I have an Access 2000 report that runs 12 pages with only 1 page's worth of information. Page 1 displays as intended. Pages 2-12 display the contents of the Detail section again, once per page.
The report is based on a query, which returns only the desired results, as do the queries on which are built the report's 8 subreports. There is a Report Header, a Report Footer and a Page Footer.
It's not a matter of margins or page setup, as far as I can tell.
Any help is greatly appreciated!

 

[dhookom]

Normally you are displaying a level of detail in the main report that isn't necessary since the same detail is explained in a subreport.

Duane
Hook'D on Access
MS Access MVP

 

[PSchubert]

Thank you for your response, Duane. In this case, none of the data refers or is duplicated between the main report and any of the subreports. The report as a whole is an invoice. The main report contains company and client name, address, etc., billing period, due date and the like (this is all in the Report Header). The subreports are in the Detail section, and contain the previous balance, breakdowns and totals for charges and credits, and the total billed. The Page Footer contains time, date and page number, and the Report Footer contains company telephone, fax and email.
Everything fits onto one page with room to spare, except for the Report Footer, which shows up on page 12, after the Detail section has been repeated on pages 2 - 12. These are the pages I'm trying to get rid of. Help? Anyone?

 

[dhookom]

What is the record source of the main report? What do you see if you place a text box in the Report Header section with a control source of:
=Count(*)

Duane
Hook'D on Access
MS Access MVP

 

[PSchubert]

Thank you for the follow-up, Duane. The reocrd source of the main report is a query, "qryInvoice," which uses fields from two different queries and two different tables: one query contributes the company's information, the other contributes the client's; one table contributes the rates and terms, the other contributes invoice information such as invoice number, billing period and due date.
A text box placed in the Report Header with a control source of "=Count(*)" shows "12" in print preview, the same as the number of pages the report is generating. Should I understand this to mean that it is either the Report Header or qryInvoice that's responsible for the redundant pages? Hmmm, now I might have an idea...
Your input is welcome and appreciated.

 

[PSchubert]

Here's what I discovered, though my attempts to put it to use have so far been unsuccessful: twelve pages are generated because there are twelve clients. When I added another client, thirteen pages were generated. I need to limit qryInvoice to return one client only. I was able to do this, but then rptInvoice showed blank.... Hmmmm....

 

[PSchubert]

Got it. The answer was to join [qryClients].[idxClients] to [tblInvoice].[nfldidxClients] within qryInvoice. Thank you, Duane, for getting me onto this train of thought.