Field list in Pivot Table or Pivot Chart view does not include fields from Subdatasheet (278392)
The information in this article applies to:
This article was previously published under Q278392 Novice: Requires knowledge of the user interface on single-user
computers.
This article applies to a Microsoft Access database (.mdb) and to a
Microsoft Access project (.adp).
SYMPTOMS When you use the expand indicator (+) in Datasheet view to display related records in a subdatasheet,
the fields from those records are not available for selection if you switch to
Pivot Table or Pivot Chart view. RESOLUTION You can include fields from both tables by creating a
query, a function, a view, or a stored procedure that joins the related tables,
and then design the pivot table or pivot chart from that query. To
include fields from the Products table as well as from the Orders table in a
Pivot Table view in the Northwind.mdb sample database, follow these steps.
CAUTION: If you follow the steps in this example, you modify the sample
database Northwind.mdb. You may want to back up the Northwind.mdb file and
follow these steps on a copy of the database. - Start Access, and then open the sample database
Northwind.mdb.
- Create a new query in Design view.
- In the Show Table dialog box, add the Orders, Order Details, and Products table to
the query, and then close the Add Table dialog box.
- Double-click the title bar of the Products field list to
select all the fields, and then drag them to the query design grid.
- Double-click the title bar of the Orders field list to
select all the fields, and then drag them to the first column of the query
design grid.
- On the View menu, click Pivot Table View.
Note that the fields from the Products table as well as from
the Orders table are available for selection.
Modification Type: | Minor | Last Reviewed: | 8/11/2004 |
---|
Keywords: | kbDatabase kbdesign kbtshoot kbprb KB278392 |
---|
|