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

[Holly C]

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.

 

[Rick Brandt]

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.

Is the properties table included in the query for the main report? It should
not be.

 

[Holly C]

I am very new at this. Properties table?

Is the properties table included in the query for the main report? It should
not be.

 

[Rick Brandt]

I am very new at this. Properties table?

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.

 

[Holly C]

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?

 

[Holly C]

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?

 

[Larry Linson]

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

 

[Holly C]

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

 

[Holly C]

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

 

[Rick Brandt]

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?

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.

 

[Holly C]

Thanks for all your help. I appreciate it very much.