DCount and Multiple Conditions

D

DK

=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?
 
T

Tom Lake

DK said:
=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?
Click to expand...

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
 
Top