Adding a second table makes my report print 2x of the same page?

[john141]

Hi, hopefully this makes sense. Just a bit confused as to why this is happening. I have a query in which has just one table.

It produces the following report which i print as a label (1 A4 page). Note in the bottom left it is printing just 1 page.

However, i want to add another table to my query like the below.

The issue with this, is without even adding any other fields or anything the label above prints 2 pages. It now says this report is 2 pages and both pages are the EXACT same label with no differences. Why would adding another table duplicate my label onto a second page. Any idea how i can get this back to 1 page whilst keeping the table?

 

[Gasman]

Group By or Distinct in the query ?

 

[john141]

Group By or Distinct in the query ?

Ahh i am using SELECT DISTINCTROW [QryStock].[product] FROM [QryStock];

could this be the issue?

 

[arnelgp]

try removing DISTINCTROW from your query.

 

[Gasman]

Well if the rows differ?

 

[john141]

try removing DISTINCTROW from your query.

Unfortunately removing this does nothing

 

[john141]

Well if the rows differ?

The rows used for this report are the exact same. I just want to access the query on a different report which uses the second table. The report in question doesn't reference the second table or any fields from it

 

[arnelgp]

just use 1 table?
the other table is Joined but is useless since it does not output anything to the report.

 

[john141]

just use 1 table?
the other table is Joined but is useless since it does not output anything to the report.

The second table is used to output to a separate report. Just not the report in question.

 

[The_Doc_Man]

If these reports are commonly used and the queries are not dynamically created, build two queries, one for each report.