Simple Query

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

From: "Tony" <[email protected]>
Subject: Simple Query
Date: Friday, 6 July 2007 10:29 PM

Hello We are developing a database for our Aboriginal Community
(Thamarrurr).
We have a data base of people and their language group.
I want a query that list the language group and the number of people who are
in it.
eg Murrinh-Patha 100
Emmi 300
Nhan Gitjemerri 600

Please help
 
Tony said:
Hello We are developing a database for our Aboriginal Community
(Thamarrurr).
We have a data base of people and their language group.
I want a query that list the language group and the number of people who are
in it.
eg Murrinh-Patha 100
Emmi 300
Nhan Gitjemerri 600
Click to expand...


Depends on your table structure. If the language group is
in the people table, then just use a Totals type query:

SELECT [Language Group], Count(*) As Speakers
FROM [your table]
GROUP BY [Language Group]
 
Back
Top