number of claims v. number of patients

[pbuethe]

I have a query that is as follows (all data is from one table):

Claims ID - Count
Provider Nbr - Group By
Provider Name - Group By - Ascending
Patient Nbr - Group By - Ascending

This will give me the number of claims for each patient number for each provider. I need to get a listing by the number of patients that have each number of claims. i.e.

how many patients (by patient number) have 10 claims, etc.

ultimately I need to have a report on the number of patients per provider with more than 7 claims.

Thanks for your help.

 

[Dugantrain]

The easiest way would be to write a query off of this query that you've already written and in your 'Count_of_Claims' Field add criteria as >=7. This will then return only Patients and their Providers with 7 or more Claims.

 

[pbuethe]

Thanks Dugantrain and Pat. I got what I wanted with 2 more layers of queries. One had the count of the count of claims, the next the sum of the count of the count. (The >7 was added as criteria in the original query.)