DCount within a Group

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.
 
D

De Jager

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top