counting the status types

  • Thread starter Thread starter JRough
  • Start date Start date
J

JRough

I have this query to sort the status of claims.

SELECT 07.STATUS, 07.CLAIMNO
FROM 07
GROUP BY 07.STATUS, 07.CLAIMNO;


What I really want to do is see how many of each type there are. For
example, there are 238 status 1 claims, some 2 claims and some 3
claims and the rest are 9's. I need to know the counts of each also
need to know if there are any nulls.

Can you help me out with this query?

tnx,
 
SELECT 07.STATUS, Count(07.CLAIMNO) as CountClaims
FROM 07
GROUP BY 07.STATUS


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

total count 2
Lost data in Union Query 4
Help with SQL 3
Totaling a query 2
query drops records 2
Totals Query with Multiple Counts 3
group by and count null values 6
Crosstab query, help 5

Back
Top