DCount within a Group

  • Thread starter Thread starter Scott Albright
  • Start date Start date
S

Scott Albright

I have a report that groups students by grade. Within each grade is the
student's name. If the student's parents are divorced, the report will show
the student twice, once for the dad and once for the mom. I need a unique
count(w/o dupes) of the students within each group. I am currently using
DCount but I'm getting the count of the entire school. The DCount is now in
the group on the report, but it doesn't matter where I put it, the count is
the same.
 
Scott Albright said:
I have a report that groups students by grade. Within each grade is the
student's name. If the student's parents are divorced, the report will
show
the student twice, once for the dad and once for the mom. I need a unique
count(w/o dupes) of the students within each group. I am currently using
DCount but I'm getting the count of the entire school. The DCount is now
in
the group on the report, but it doesn't matter where I put it, the count
is
the same.
Click to expand...
 
Back
Top