Simple Query

[Tony]

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

 

[Joan Wild]

SELECT [language group], Count([People]) AS CountOfPeople
FROM YourTable
GROUP BY [language group];

You'll need to edit this to reflect the actual names of your table and fields.

Open a new query and dismiss the Add Table dialog; Then View SQL View and paste the statement above.

 

[PACALA]

NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
[email protected]
SKYPE: PACALA.BA1

 

[tina]

these newsgroups are for the FREE exchange of ideas, information, and
assistance. this is absolutely NOT the place to troll for business, such
postings are not welcome, and they make such a bad impression that it can
only hurt your reputation in the Access community.

if you want to post actual advice and assistance here in the newsgroups for
all to benefit from, or post questions of your own, then your participation
will be welcomed.

NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
[email protected]
SKYPE: PACALA.BA1

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

 

[Steve]

Hooray for you!! You and Arno R (the Rat) ought to get together.

these newsgroups are for the FREE exchange of ideas, information, and
assistance. this is absolutely NOT the place to troll for business, such
postings are not welcome, and they make such a bad impression that it can
only hurt your reputation in the Access community.

if you want to post actual advice and assistance here in the newsgroups
for
all to benefit from, or post questions of your own, then your
participation
will be welcomed.

NO PROBLEMS, CONTACT ME...
--
PACALA JAN [ACCESS DEVELOPER]
SEND 10$ TO...
ACCOUNT:
SK31 1100 0000 0026 1674 0428
SwiftCode: TATRSKBX
Tatra banka as,Hodzovo nam.3, 811 06 Bratislava
[email protected]
SKYPE: PACALA.BA1

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