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.
 

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

Similar Threads

Counting Unique Values within a Group 2
DCount help 1
Dcount question 6
Counting Records in A Group 5
DCount in group footer 4
DCount 4
DCount problem 3
HELP A NEWBIE - EXCEL TO ACCESS 5

Back
Top