count distinct value within a report

  • Thread starter Thread starter terrell
  • Start date Start date
T

terrell

How do I count distinct social security number(ssn)within
a report driven by a query that includes multiple records
for some ssn's?
 
You could add a SSN group header. Then add a text box to this header
section:
Name: txtSSNCount
Control Source: =1
Running Sum: Over All

Then add a text box to your report footer:
Control Source: =txtSSNCount
 
Back
Top