I have a report that lists students by grade and the amount of money donated
by that student's family. If the parents are divorced, the student's name is
listed twice, once for each parent. I want to count only the unique student
record in each grade. DCount is giving me the count for the whole school
regardless of what group detail i put it in. How do I count only the unique
records within each grouping?

Thanks in advance.

I would attempt to create a totals query that groups by whatever and counts
something. Add this totals query to your report's record source and join on
the whatever so the counts something is then available in the report.


"Scott Albright" <(E-Mail Removed)> wrote in message
news:59367CC6-151B-43D4-92AF-(E-Mail Removed)...
> I have a report that lists students by grade and the amount of money
> donated
> by that student's family. If the parents are divorced, the student's name
> is
> listed twice, once for each parent. I want to count only the unique
> student
> record in each grade. DCount is giving me the count for the whole school
> regardless of what group detail i put it in. How do I count only the
> unique
> records within each grouping?
>
> Thanks in advance.

This gets asked reasonably often, so here is a new article:
ECount() - an extended DCount()
at:
http://allenbrowne.com/ser-66.html

ECount() takes the same arguments as DCount(), but an extra flag you can set
to retrieve the distinct count.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

Scott Albright wrote:
> I have a report that lists students by grade and the amount of money donated
> by that student's family. If the parents are divorced, the student's name is
> listed twice, once for each parent. I want to count only the unique student
> record in each grade. DCount is giving me the count for the whole school
> regardless of what group detail i put it in. How do I count only the unique
> records within each grouping?
>
> Thanks in advance.