DCount and Multiple Conditions

[Guest]

=DCount("[InterviewComplete]","Table Name","[InterviewComplete]=Yes")

I have created this DCount calcluation which works but I want to be be able
to add a condition so I can get this summary by Interviewer so I can produce
a Summary at the bottom of my report.

How do I manipulate this statement to do so?

 

[Tom Lake]

=DCount("[InterviewComplete]","Table Name","[InterviewComplete]=Yes")


I have created this DCount calcluation which works but I want to be be
able
to add a condition so I can get this summary by Interviewer so I can
produce
a Summary at the bottom of my report.

How do I manipulate this statement to do so?

If you pout a Count (NOT DCount) function in the group footer, you'll get a
count of just the people in that group.

Tom Lake