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 > Crosstab

1. Create a Crosstab Query.

Double-click "Create Query in Design View" in the Queries area of the main database window. Add the "qr_sample_p_and_h" table, then choose Query->Crosstab Query. Drag-and-drop the "incws_c," "sex," and "serialno" variables into the data table. Use File->Save to save and name this query "qr_incws_c_sex."

The "Crosstab Query" option added a row labelled Crosstab.

2. Set up the query as shown below by right-clicking the "Total" row in each column and choosing the appropriate option, and then doing the same for the "Crosstab" row..

3. Run the query (click on "!") and check the result. The rows are the Wage/Salary categories and the columns represent the gender categories (1 Male, 2 Female). The cell values are the number of people (count of records).

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