Forum Discussion
Solved
How to create a report that counts unique values in one field
I have a database that lists clients, their info and who referred them. I want to make a report that lists all the people who referred, and how many people they referred. I don’t know if it can be d...
Create a Totals query by clicking the Sigma symbol on the Query Design ribbon
SELECT Referred_by, Count(Client) AS TotalReferrals FROM YourTableName GROUP BY Referred_by;Use that query in your report
Create a Totals query by clicking the Sigma symbol on the Query Design ribbon
SELECT Referred_by, Count(Client) AS TotalReferrals
FROM YourTableName
GROUP BY Referred_by;
Use that query in your report
Thank you for being willing to help. All this does is change the name of the field Referred_by to TotalReferrals and puts a 1 instead of the name.
- No. It creates the required output you asked for in the original post ... provided you use your actual table name in the query
- Thank You! I was trying to incorporate it into a current query instead of creating a new one with just that script. Sorry I doubted 🙂