Microsoft Office Tutorials and References
In Depth Information
Creating a crosstab query with the Query Wizard
Creating a crosstab query with the Query Wizard
Crosstab queries can be constructed manually. However, it is
simpler to use the Query Wizard to create the query, which you
can later change in design view.
6
Create a crosstab query
1 Click the Create tab.
2 Click Query Wizard.
3 In the New Query popup window, click Crosstab Query Wizard.
4 Click OK.
5 In the Crosstab Query Wizard, click Queries.
6 Select a query and click Next.
7 Select one or more columns to act as row headings, and click Next.
(continued on next page)
1
2
5
7
3
4
Search JabSto ::




Custom Search