popdata

[ikodlc]

I used “popdata” to reveal the number of people of certain nationalities living in a certain country. The numbers were translated into the location and the nationalities. I need to find a place in the country where the most number of a certain nationality is. How do I do that?

[weekend00]

create query1 to do a count of the nationality for all cities;
cerate query2 to pick the cities with the max number from query1.

[ikodlc]

Yes, but in our class, we were able to get them to become words. And we need to find the total number of the nationalities in a specific area. Would you know how to do that?

[weekend00]

you need to write a functin to convert number into "words", or you may try to find one from internet.
http://www.ozgrid.com/VBA/ValueToWords.htm

[ikodlc]

Thank you!