Click the Create tab.
Click Query Wizard.
Click Crosstab Query Wizard.
Click OK.
Click the table or query to provide the values for your crosstab query.
Click Next.
Click the field to provide values for the row headings.
Click Add.
Click the field to provide values for the column headings.
Click the field to provide values for the data area (body) of the crosstab query.
Click the summary calculation to be performed on the values in the data area.
Type a name for the query.
Click Finish.