Count instances of groupings

J

jonefer

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?
 
D

Duane Hookom

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
 
Top