DCount within a Group

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.

You need to use DCount with the appropriate WHERE clause, but without seeing
your code and knowing what your table/query looks like, I can't say more than
that. What is the source of the report - a table or a query?

Please give us more details.

John


Scott Albright wrote:
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.

--
John Goddard
Ottawa, ON Canada
jrgoddard at cyberus dot ca

Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...ccess/201003/1

"Scott Albright" wrote in message
...
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.

ilmmlm

"Scott Albright" a écrit dans le
message de groupe de discussion :
...
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.