Solved Report giving repeat body display

[jgcns]

Dear all,

Finally I got to the Report Part, but i am facing an issue... My report is showing repeated bodies. for each record ( Purchase Order) it shows repletely the same info as many as the number of records of Sub Report..

Please FInd some pictures for a better understanding.

The Control source is a query created by me that mixture Purchase Order table with Requisition and Spare part List

Do you know what are the possible causes?

Thank you in advance!

 

[theDBguy]

Hi. It's not clear to me which records are repeated in your report by just looking at those images. I see multiple plugs, but they all have different quantities.

 

[jgcns]

they are screenchots on after another
they make a single report

 

[Rene vK]

There must be something wrong with the JOIN in your query.

 

[jgcns]

well deleting all other tables it works fine... i'll get the info by other way. Thanks!

 

[theDBguy]

well deleting all other tables it works fine... i'll get the info by other way. Thanks!

Hi. Glad to hear you got it sorted out. Good luck with your project.