The easiest way to create a CrossTab Query is through the wizard. To do this, switch to the Queries section of the database window and click New.

 

 

Then, in the dialog that opens, select CrossTab Query Wizard and click OK.

 

 

Step 1 of the Crosstab Query Wizard asks you to choose a table or query to pull the fields from.

 

 

Next, select the fields that you want your information grouped by. In this case, we’re going to group fields by Transaction Date. Note that you must click the right-facing arrow (>) to add the field to the Selected Fields list.

 

 

Next, choose what value you want as a column heading.

 

 

Finally, we’re going to specify what sums we want in the query. In this case, we’re going to choose Withdrawal Amount, choose Average for the mathematical function, and click Next.

 

 

Our last step names our query.

 

 

Once we click Finish, you will see the query results. Before we look at them, though, let’s review what we told the wizard to do.

 

What table do we want to use?	Transactions.
What do we want for row headings?	Transaction Date.
What do we want for column headings?	Transaction Description
What data do we want summarized?	The average of each withdrawal.

 

So now we have a table showing the date of each business expense, the average withdrawal for that date, and breakdowns of each expense.