Crosstab Query Wizard :
This wizard creates a crosstab query that displays data in a compact, Spreadsheet-like format.
Steps :
- Create the table based on below format.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-IRvFjh2bZoJ07pwC_HvOZc_L0AaMkduNOw5caFm7ZVkEECuACk-lEgTy8nzmKwQZ1xaP1H49Z8wLxfRsn-ytwHFDgpUYfK0zRloCcsuWYd1i3GZ-7VhuEteBcjt4nvMQOBkdk4oVQuA/s640/crosstab1.jpg)
- Enter the Data
- Click on Create Tab
- Then Click on Query Wizard
- Choose the Crosstab Query
- Click on Ok Button
Example :(Table Name : Music Album)
- Select the field/s that you want to be row headings. (You can select up to three fields. However, in this example, we only select one. (Artist_Name)) .
- Click Next Button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgT-20dTKpWsrAk_CpEs_rLrEIGJUCdet_kPvOKTiQ2zvtqyx0_IN_GMpIZAyAahdjp8jfgW8qVJSnhM7hSBbXBBk8bmjezU9PXHgS-zLiXU0ewjD8zEZP2Yvbt1LHzN86hjeXCLhiH-Qo/s400/crosstab6.jpg)
- Select the Column Heading (Example : Genre)
- Click on Next Button
- Select the Data Field and Function (Example : Field Name : Album_Name, Function :Count).
- Click on Next Button.
![](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEghMB84ugTCExYUk4ORLYcXKSQgPAWlhnkPLwHaINMjUOdj3iBXp3FNFljRvLbOzrMc8ud2nmq3JLljUbVrucOrw1iOWcFqzNLvvgYdL7bzYWs22ngKGucvYVoDq55L32YueTTk3_mOqxA/s400/crosstab8.jpg)
- Type the Query Name
- Click on Finish Button
Result Table :
Follow @Sarvavasi.com