Michael Franz
asked on
How to count / group distinct records in Access
I have a MS Access 2003 table that hold information regarding customers insurance polices. I need to, for lesser terms, count / group them together. Attached is an example of the data set and the result I am trying to achieve.
Customer-Counting.xls
Customer-Counting.xls
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks!
Generally, here's how...
Start a new query. Select the customers and policies.
Click on the totals tool (group by).
In the Totals Line set customers to Group By and Policies to Count
Post your databse and I can help in more detail.
Regards,
Bill