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:

Access Database Templates:
Inventory Software Access Templates
Inventory Systems. Review our custom Inventory Software. Barcode Asset Tracking & Control Microsoft Access database.

Interior Design Project Template Software
Manage Interior Design projects with this simple and powerful Access database system.

Access Contact Management Access Templates
Contact Management, Custom Contact Management Software, Organize Contacts & Communications.

Construction Project Management Access Template
Construction Project Management designed to help you keep on budget and on time.

Lease Contract Management Software
Create lease contracts & Rental agreement for equipment. Analysis lease performance & cash flow.

CRM/Customer Relationship Management Template Database
Customer Management Tools. Custom CRM Software Solutions.
Manage Customer & Client Relations Microsoft Access software.