DCount by Group

[Guest]

I have a database that tracks individuals and status of classes - Completed,
Passed or Null if they haven't attended.

I have a report that is grouped by Organization. I want to be able to count
the number Passed and the number Completed for each organization. When I
insert the DCount function, I get the total for the report not for the group.

What am I doing wrong?

Thanks for any help

 

[John Vinson]

I have a database that tracks individuals and status of classes - Completed,
Passed or Null if they haven't attended.

I have a report that is grouped by Organization. I want to be able to count
the number Passed and the number Completed for each organization. When I
insert the DCount function, I get the total for the report not for the group.

What am I doing wrong?

Probably using incorrect criteria in the third argument of the DCount
(which you didn't post).

I'd suggest instead grouping the Report by organization and then by
status and doing the counts in the Report grouping, though - probably
simpler!

John W. Vinson[MVP]