How do I not count duplicate records in a report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a report page footer, am attempting to count the number of individuals in
group, without counting any individual more than once - even if that
individual has numerous records in the group. Have tried "Record counts" but
this procedure returns a count which includes the number of occurreneces an
individual record appears in the group rather than counting the individual
only once.
 
I would create a totals query that groups by your un-named group and
individual field. Then create another totals query that groups on only the
un-named group and counts the individual groups. You can then add this final
totals query to your report's record source and include the Count of
Individual groups in your report.

There is another method that creates groups by individuals and uses a
running sum on a control.
 
Back
Top