Link to home
Start Free TrialLog in
Avatar of anglandp
anglandp

asked on

MS Access - performing a count

Good afternoon - I have a table with court cases in it, and we're trying to figure out how many cases are tied to each court. Can someone help me with a query?

Table: tblCase
caseID
CaseName
CourtName

Ideally, the query would return the court name, with a count of all cases in that court.

Thank you kindly!
ASKER CERTIFIED SOLUTION
Avatar of PJBX
PJBX
Flag of United States of America image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ross Turner
Ross Turner
Flag of United Kingdom of Great Britain and Northern Ireland image
Hi

I've attached an example ms db and query but the code is as following 

SELECT tblCase.Courtname, Count(tblCase.Casename) AS CountOfCasename
FROM tblCase
GROUP BY tblCase.Courtname;

Open in new window

CountCourtCase.accdb