How to group data?

[hawkeye71]

Hi Folks:
Table has a column which contains students country of birth, e.g. Germany, France, Sweden, China, Japan.
I want to find out the number of students from a region of the world, e.g. Asia, Europe.

I have written two queries to do this, one for the students from Asia and one for students from Europe.

In the criteria field I used "Japan" or "China" for Asian students, and I used "Germany" Or "France" or "Sweden" for European
students.

I want to write one query to get the required results.
I need help.
Also, I need a report that can use this query and display the student count by each region and then by country in that region.

Thanks,
Indiana

 

[Blorf]

Try this

SELECT YourTable.Region, Sum(1) AS [Count]
FROM YourTable
GROUP BY YourTable.Region;

ChaZ

Ascii dumb question, get a dumb Ansi