popdata PROBLEM

[jumpingtree]

I am using popdata to reveal the number of people of a certain nationality living in another country.



i got to the point where the numbers were translated into relevant and understandable data (the location and the nationalities appeared).

the problem is, i need to find the place in the country where the most number of that certain nationality is. how do i get that using microsoft access? what tool or query should i use?

[weekend00]

Isn't the Arab number the most widely use one?

[jumpingtree]

yeah, numbers were there first like 99 etc. i tinkered it so that the words would appear. on the city column, the names of the cities appeared. on the next column, the nationalities.
my problem is to get the total number of a certain nationality. for example, to get the total number of the german in the nationalities column. and see if it is related with the cities column.

[weekend00]

my problem is to get the total number of a certain nationality. for example, to get the total number of the german in the nationalities column. and see if it is related with the cities column.

I did get what the total number mean, and how does the number relate to the cities column.

[jumpingtree]

oops. i just need the total number of the nationalities (eg. german, filipino, chinese, and a lot others). how to get that?

[weekend00]

I believe a simply aggregative query can do it.

[jumpingtree]

how to do that? i'm not really good with access.

[weekend00]

suppose you have data in the table named "nationaltytable", and the field name is "nationality", then the query may look like:

select nationality, count(nationality) from nationalitytable group by nationality

[jumpingtree]

oh. THANK YOU!

[weekend00]

you are always welcome.
May I mark this post as solved?

[jumpingtree]

yup. thank you very much!