counting the status types

[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,

 

[John Spencer]

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