Microsoft Access Database: Crosstab Queries with Microsoft Access 2003

What is a Microsoft Access Crosstab Query? Here’s the simple answer by asking a different question. Do you know what an Excel Pivot Table is? If you do, then you have just answered the first question!

In fact, Microsoft Access Crosstab queries are quite basic and limited when comparing to the newer and richer reporting outputs of a Pivot Table but it’s still in use and effective.

Take a look at this video tutorial (no more than 5 minutes) called

Microsoft Access 2003 Tutorial Crosstab Queries

The trick is to base this type of Microsoft Access query on another query which would typically be made up from related tables.

To learn more about queries of all types, take a look at one of my eBook on More Microsoft Access Queries. There are other eBooks too, Microsoft Access eBooks.

This entry was posted in MS Access, Queries and tagged , , , , . Bookmark the permalink.

One Response to Microsoft Access Database: Crosstab Queries with Microsoft Access 2003

  1. Ben Beitler says:

    The best way to undertand and then expand a Crosstab query is to first use the wizard tool and then modify it in the design view.
    This applies to all versions of Microsoft Access.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

Confirm you are human.