How to create a crosstab query with multiple value fields (304458)
The information in this article applies to:
- Microsoft Office Access 2003
- Microsoft Access 2002
This article was previously published under Q304458 Moderate: Requires basic macro, coding, and interoperability
skills. This article applies only to a Microsoft Access database (.mdb).
For a Microsoft Access 2000 version of this article,
see
209143. For a Microsoft Access 97 version of this article,
see
109939. SUMMARY In a Microsoft Access crosstab query, you can specify only
one field or calculation as the value. You may want to show more than one value
in the query. The following example shows two columns of information
per company, a count of the number of orders, and the order totals for each
year:
Company Name 1998 Orders 1998 Total 1999 Orders 1999 Total
--------------------------------------------------------------
ABC Company 12 $855.00 15 $1010.25
XYZ Company 1017 $22045.57 1050 $25345.29
This type of query is sometimes called a Multiple Value Field
query. REFERENCESFor
more information about crosstab queries, click Microsoft Access Help on the Help menu, type crosstab queries in the Office
Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type: | Minor | Last Reviewed: | 6/8/2004 |
---|
Keywords: | kbQuery kbhowto KB304458 kbAudDeveloper |
---|
|