DCOUNT HELP!

[Guest]

I am trying to dcount the total records in a group (report) the footer of
each grouped employee and a specified rating. The problem I am having is my
dcount is dcounting all employees and the specified rating in the report
below is my code. I appreciate the help.

=DCount("[PerformCode] = 'BE'","erptEEsPerformEvaluate","[EEID] =
Reports![Employees Performance Evaluation]![txtEEID]")

 

[Marshall Barton]

I am trying to dcount the total records in a group (report) the footer of
each grouped employee and a specified rating. The problem I am having is my
dcount is dcounting all employees and the specified rating in the report
below is my code. I appreciate the help.

=DCount("[PerformCode] = 'BE'","erptEEsPerformEvaluate","[EEID] =
Reports![Employees Performance Evaluation]![txtEEID]")

You can calculate the number of detail records in any group
level by using the expression =Count(*)
If you're trying to count only the ones that match a
specific value, then you woulf do it this way:
=Sum(IIf(PerformCode = 'BE', 1, 0))

If you really need to use a Domain Aggregate function, try
this:
= -DSum("[PerformCode] = 'BE'",
"erptEEsPerformEvaluate", "[EEID] = " & Reports![Employees
Performance Evaluation]!txtEEID)

 

[fredg]

I am trying to dcount the total records in a group (report) the footer of
each grouped employee and a specified rating. The problem I am having is my
dcount is dcounting all employees and the specified rating in the report
below is my code. I appreciate the help.

=DCount("[PerformCode] = 'BE'","erptEEsPerformEvaluate","[EEID] =
Reports![Employees Performance Evaluation]![txtEEID]")

DCount counts all records in your table, not just the ones in the
report.
In the Group Footer =Count(*) will count all the records in that group
in the report.
If you wish to count only those in the group that meet certain
criteria, then, in the Group footer:
=Sum(IIf([SomeField] = Criteria,1,0))

 

[Guest]

THANX!!! Marshall and Fredg
--
Thanx!

I am trying to dcount the total records in a group (report) the footer of
each grouped employee and a specified rating. The problem I am having is my
dcount is dcounting all employees and the specified rating in the report
below is my code. I appreciate the help.

=DCount("[PerformCode] = 'BE'","erptEEsPerformEvaluate","[EEID] =
Reports![Employees Performance Evaluation]![txtEEID]")

You can calculate the number of detail records in any group
level by using the expression =Count(*)
If you're trying to count only the ones that match a
specific value, then you woulf do it this way:
=Sum(IIf(PerformCode = 'BE', 1, 0))

If you really need to use a Domain Aggregate function, try
this:
= -DSum("[PerformCode] = 'BE'",
"erptEEsPerformEvaluate", "[EEID] = " & Reports![Employees
Performance Evaluation]!txtEEID)