Totalling rows in a query

[Guest]

I have a query and all I want is total of rows per each department in the
hospital. I have tried setting up a table to make the departments numeric
but still cannot get the total function to count all the 1s and then all the
2s and show me how many of each there are.

 

[Guest]

Try this --
SELECT AlisonD.Department, Count(AlisonD.Department) AS [Department Count]
FROM AlisonD
GROUP BY AlisonD.Department;