Crosstab Query Download

The crosstab query is one of the strangest queries you'll come across. Many relational database management systems do not include crosstab queries in there native query types.  Thankfully Access does.

In the downloadable example we show how to count up total sales of clothing items and group the data by date and item type.

Try to recreate the crosstab query using the crosstab query wizard within the 'create a new query' option.

You can also adjust column widths and hide columns that you don't want shown.

Use this link to download the Access crosstab query example.

Here is a snapshot of the query in design view: