Sorting Problem

[quetzalcotl]

Hi. In school we had this task where we were to get a data that contains facts about 1% of people living in large US cities at the time on the last US census in 2000. The file gives the name of the city and the racial/ethnic ancestry of the person concerned. We were asked to put all these data together (since the US city, ID number of a person, and their racial/ethnic ancestry are all in separate files; aside from the file containing the ID numbers of the same three variables) and so I came up with this:

How I did that: I converted the "city numbers" and "ancestry numbers" columns to lookup variables that display the name of the city and ancestry group on the other tables.

For our next task, we have to create a sorted list showing the number of Filipinos living in each city (with the cities with the largest number of Filipinos at the top). Our professor clued in that we have to use SQL for this.

Unfortunately, I still haven't figured the whole thing up. Would someone please help?

P.S. If you're confused with what I'm talking about, here's a link to our task's instructions. It includes the first task I'm already done with, as well as the second task I'm having trouble with:

http://www.keepandshare.com/doc/2174004/accessexercise-pdf-august-22-2010-10-03-pm-258k?da=y

 

[jal]

Generally, if you have two or more separate tables, you can, if the tables are related (i.e. a relationship pointer-line is drawn in Relationships View between the tables), use the wizards and graphical tools to produce a report showing desired data from each of the tables.

Generally, behind the scenes, the wizards are writing INNER JOIN queries in SQL syntax. With a little practice, you can write these INNER JOIN queries yourself (and paste them into SQL View and save them as saved-queries). You definitely should learn SQL if you want to become a programmer, although the wizards usually work just fine for simple reports.