I am getting duplicate pages in my report. How can I fix this?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The data is correct on each page, but I do not want 2 pages with the same data.
I have created an invoice, on the invoice - Owner and in the subreport are
the owner properties...this data is correct, however if an owner has 2
properties I am getting 2 invoices with both properties on each page.
 
Holly said:
The data is correct on each page, but I do not want 2 pages with the
same data. I have created an invoice, on the invoice - Owner and in
the subreport are
the owner properties...this data is correct, however if an owner has 2
properties I am getting 2 invoices with both properties on each page.
Click to expand...

Is the properties table included in the query for the main report? It should
not be.
 
Holly C said:
I am very new at this. Properties table?
Click to expand...

Your table that contains data about properties ("an owner has two properties").
Is that table included in the Parent report's RecordSource query? If you are
using a subreport for property data then the properties table should not need to
be in that query.
 
The report is created from a query called All Active Info...this query has
property info, tenant info, owner info, management co info. The subreport is
also created from the same query. Is that what you mean?
 
I have changed the main report to Query-Owners and the subreport to All
Active Info. This seems to be working. Now how do I get the report to only
show owners that have units, instead of showing blank invoices? Or can I?
 
Use criteria on the Query so the Query doesn't retreive Records unless the
Owner has Units. Just an idle question, though: If they do not own a Unit,
how do they qualify as an Owner?

Larry Linson
Microsoft Access MVP
 
Larry Linson said:
Use criteria on the Query so the Query doesn't retreive Records unless the
Owner has Units. Just an idle question, though: If they do not own a Unit,
how do they qualify as an Owner?

Larry Linson
Microsoft Access MVP
Click to expand...
 
Good question. Why am I getting Owner's Invoices for owners that no longer
have properties. Something to do with the Active? field I bet
 
Holly C said:
I have changed the main report to Query-Owners and the subreport to All
Active Info. This seems to be working. Now how do I get the report to only
show owners that have units, instead of showing blank invoices? Or can I?
Click to expand...

Well if you need to apply criteria on the properties table then it might need to
be included in the query, but the query should be constructed so that you still
only get one row per owner regardless of the number or properties they have.

Another option is to revert the query to the way it was and create a group
section on your report that groups on the owner primary key field. If you put
all controls (including the subreport) within that section that should also
eliminate any duplicates per owner.
 
Back
Top