My observations...
1. You cannot use...
...because that is saying count ALL the records in that section.
2. You cannot use the...
...function in the Group Header and expect it to know the difference between *Open* records and *Closed* records. You might get away with...
Code:
=DCount("[Status]","[Lead Activity Report]",[Status]="Closed")
..in the query and then use the Sum() function to get the results to show on your report.
3. I'm also a little concerned that there is only one table. Are there more tables? Perhaps you should take a look at...
Jeff Conrad's resources page...
http://www.accessmvp.com/JConrad/acc...resources.html
The Access Web resources page...
http://www.mvps.org/access/resources/index.html
A free tutorial written by Crystal (MS Access MVP)...
http://allenbrowne.com/casu-22.html
MVP Allen Browne's tutorials...
http://allenbrowne.com/links.html#Tutorials
Sample data models...
http://www.databasedev.co.uk/table-of-contents.html