DCOUNT HELP!

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

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]")
 
Tru said:
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]")
Click to expand...


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)
 
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]")
Click to expand...

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))
 
THANX!!! Marshall and Fredg
--
Thanx!


Marshall Barton said:
Tru said:
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]")
Click to expand...


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)
Click to expand...
 
Back
Top