The following process is used to create Cross Tab Querie:
Some step in this tutorials are simple but some step required some explanation. For example what is Row Heading and column heading.
If we have a table with some data:
Row Heading:
In This section we select the Table Field which display as row heading. you can select one or more row heading. From above table we select ID and Customer_Name as Row Heading.
Column Heading:
This cross tab option is represented horizontally in your dataset. Good candidates for this grouping are sales quarters or other categories of data for which you want only one grouping aggregation, because only one column heading is allowed in a cross tab query. From above table we select Payment_Month as Column Heading So the value of This field Display As column Heading .
In the end Payment filed from above table we select as calculated filed and sum as our function. The value of This filed are display in Column and row intersection.
The final result of our cross tab query is :
You can see the Name are display in the row heading. Each value of the Field Month Converted in to Column and The Payment values are display in the Column and row intersection.
Creating Split Forms in MS Access 2007
Cross tab query in Microsoft Access
How We Set a Default Form In Access 2007
Creating a Parameter Query In MS Access 2007
How We Pass String parameter in MS Access Query
Creating a Form In design View In MS Access
Creating a Check Box in Access 2007
Create a list box or a combo box by in MS Access
Creating a New Form through Wizard In Access 2007
How To Create A Table in Access 2007
How to Create a New Database Access 2007