Report : Dulicating Text Box

[Hayton]

Good Morning everyone,

Have a report (rptReport) which has a query (qryFactory) as its Record Source. I have placed a Text Box(txtBD) in the details section of the report.. The Control Source for the the Text Box is : =DSum("[CountOfFailRsn]","qryFactory","[FailRsn]='Bead Damage'&quot

When I run the report the Text Box calculates the correct result but duplicates itself about fifty times in the report.

How do I stop the duplication?

Thanks in advance

 

[Hayton]

Don't worry I have workrd it out.

Wisdom - knowledge applied