How to create a crosstab query in access2010 How to create a crosstab query in access2010

Do you need to create a crosstab query when using Access 2010 in office? don’t worry! PHP editor Yuzai will introduce in detail how to create a crosstab query in Access 2010. Continue reading below to learn how to easily and quickly create crosstab queries and organize and analyze your data.

How to create a crosstab query in access2010? How to create a crosstab query in access2010

Open Access2010

Click the [Open] menu, select the database file name, and then click [Open]

The database is now open

Click to open database table, such as product

Click [Create], then click [Query Wizard]

Select [Crosstab Query Wizard], and then click [OK]

Select the table, and then click [Next]

Select the fields and click [Next]

Select the row header fields and click [Next]

Select the column headers and click [Next]

Select the number calculated by the intersection and click [Next]

Enter the query title and click [Finish]

The crosstab query is now created

The above is the detailed content of How to create a crosstab query in access2010 How to create a crosstab query in access2010. For more information, please follow other related articles on the PHP Chinese website!