displaying the number of each values

[hklein]

Hi,

I am quite new to make access queries, and I am sure that this question is very simple.


I have a table with the following columns:
ID
Group_Id
Name

I would like get the number of occurences of each Group_id

(How much people are in group A, groub B, etc. )

Could anybody help?

Thank you

[pbaldy]

Try

SELECT Group_Id, Count(*) AS HowMany
FROM TableName
GROUP BY Group_Id

[hklein]

many thanks, this is what I was looking for, it works.

[pbaldy]

No problem, and welcome to the site by the way!