Recent content by john141

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

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

Unfortunately removing this does nothing

Ahh i am using SELECT DISTINCTROW [QryStock].[product] FROM [QryStock]; could this be the issue?

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...

That works perfectly, had no idea it would be that simple! Makes sense now I am looking at it though Thank you :)

I have created a form called ProductLabels. This form is filled out and it produces the following report which is printed as a label. The part in question is the Serial / Batch. This line is : =Trim([Forms].[Frm_ProductLabels].[part_no]) & "/" & [Forms].[Frm_ProductLabels].[Text16] part_no...