DCount and Multiple Conditions

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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
 
Back
Top