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:
