COUNT() Function Usage

[Vem786]

Hi:
I'm using count() function in a SQL Query in MS Access as --

SELECT COUNT(Dept), Prof_Name FROM Departments WHERE Dept IN ("English","Math","Engg"

When I save this & hit RUN, Access specifies Error saying "You Tried to execute a query that does not include the specified expression "Prof_Name" as part of an aggregate function".

Can anyone get me this query running??

I'm supposed to do this Count by "Dept" the Number of Prof_Name.

Thanks!!

 

[nicsin]

in sql, if you have aggregate functions you have to group by all the fields that are not included in the aggregate functions. So,

SELECT COUNT(Dept), Prof_Name FROM Departments WHERE Dept IN ("English","Math","Engg") GROUP BY Prof_Name;

 

[Vem786]

Thank You!!!