|Crosstab queries are more
powerful than the other types of queries that have been listed so far. They
work by consolidating other Access tables and databases into a row and column
format, which is much easier to read and to use to find information.
|There are two methods to
create a Crosstab query, The query design view and the “create query wizard”.
The query design view can be used to create multiple types of queries,
including but not limited to crosstab queries. However, the easiest way to
create a crosstab query is by using the create query wizard. This wizard asks
you to choose the query you want, and then asks you what sets of data that
you want to select, making it very easy to create a query specific to your