Count instances of groupings

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

Guest

I have a Duplicate SSN report.

Lets say a SSN has 7 instances of 1 SSN and 2 Instances of another

Presently I'm getting the following - "Total Duplicates: 9"

I'd like the total at the bottom to say "Total Duplicates: 2"

how can I count groupings?
 
Create a Group Header on SSN. Add a text box to the SSN Group Header
Section:
Name: txtCountSSN
Control Source: =1
Running Sum: Over All
Add a text box to your report footer:
Control Source: =txtCountSSN
 
Back
Top