record count in report shows after every record

[lotarugg]

Hi, I guess there is something simple I'm missing here but can't find how to prevent the count on a report from repeating after ever record in the report. I have a text box below the feilds. In properties>data>control source I have =Count(*)

The count is good but it repeats after every record

Thanks

 

[bob fitz]

Hi

I think that you need to move the control that shows the total to the Report Footer section.

 

[lotarugg]

I found the hide duplicates options However the count appears after the first record now not the last

 

[bob fitz]

Hi

Did you try moving the control that shows the total to the Report Footer section as I suggested in my last post?

 

[lotarugg]

Hi sorry think our posts crossed. It worked what you suggested Thanks very much!