Massachusetts Institute of Technology
Department of Urban Studies and Planning

11.220 Quantitative Reasoning and Statistical Methods for Planning

MS-Access

HOME   |   TEST-OUT   |   BRUSH-UP   |   MATERIALS

MS-Access > Group-by

1. Create a query and add "qr_sample_p_and_h." Drag-and-drop the fields "incws_c" and "serialno" into the data table. Name this query "qr_incws_c" (File->Save).

We are going to count the number of people in the income data categories we created earlier. To begin, right-click in the column for "incws"_c and choose "Totals." Left-click on the "Totals" row under "incws_c" and make sure it says "Group By." Left-click on the "Totals" row under "serialno" and make sure it says "Count." Click Run (!).

2. Earlier the wage and salary income was collapsed into the following 4 categories:

blank: No or None
1: $1 - $19,999
2: $20,000 - $39,999
3: $40,000 or more

This new query has returned a count of records, i.e., people, in each income category.

Created by Myounggu Kang on January 25, 2004. Edited by Rhonda Ryznar on January 19, 2005.