Have to do a query that returns record for each person and uses the same filter criteria as the report. Use DISTINCT or GROUP BY. Then join that query to the report's RecordSource query.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
A general SQL approach is
whereCode:Select DISTINCT fieldname,Count(*) as [Count] from tablename group by fieldname;
-tablename is the name of the table containing the field
-fieldname is the name of the field for which you want the distinct count