SELECT COUNT ??? 1

[JeroenB]

Hi I have the following SQL-statement in MS Access

SELECT TYPE_DEUREN.[TYPE-NR], count ([5_Deuren].[Deur-nr]) AS AantalDeuren
FROM TYPE_DEUREN INNER JOIN 5_Deuren ON TYPE_DEUREN.[TYPE-ID] = [5_Deuren].[TYPE-ID]
ORDER BY TYPE_DEUREN.[TYPE-NR];

I get the error "You tried to execute a query that does not include the specified expression 'TYPE-NR' as part of an aggregate function'

I want to have al list of the TYPE-NR and the number of 'Deur-nr' for each of these TYPE-NR.

Can someone help me out ?

thanx
jeroenB

 

[r937]

add GROUP BY TYPE_DEUREN.[TYPE-NR] just before the ORDER BY

rudy