Access 2003: Creating Object/File for A Report of the Pivot Table

S

SHC

Hi all,
I know that the View of a Pivot Table can be derived from the existing
objects in Access 2003. But the format of the Pivot Table can not be saved in
the Access 2003 or Excel 2003 program. I need an electronic file of the
customerized Pivot Table to present in the Microsoft Word/Excel/Power Point.

Suppose a Master Table that has 3 fields -
Field1 Field2 Field3
xx1(in group1) yy1 zz1
xx2(in group1) yy2 zz2
xx3(in-group1) yy3 zz3
xx1(in group2) yy1 zz4
xx2(in group2) yy2 zz5
xx3(in group2) yy3 zz6
xx1(in group3) yy1 zz7
xx2(in group3) yy2 zz8
xx3(in group3) yy3 zz9

I want to create a Pivot Table:
yy1 yy2 yy3 (in X-Axis)
(in Y-axis)
xx1 zz1 zz4 zz7
xx2 zz2 zz5 zz8
xx3 zz3 zz6 zz9
I am thinking to do the following steps for getting the above-mentioned
Pivot Table:
1) From the Master Table, I do the Stored Procedure 3 times by querying xx1,
xx2 and xx3 and save them.
2) Under the “Report†Object, can I create a Report of the Pivot Table
from the 3 Stored Procedure tables that are put in the Relational Diagram?
This is the step I do not know how to do it!!! Any ideas/suggestions to
help me in this task? Please help and advise.

Thanks in advance,

SHC
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2003: Creating Object/File for A Report of the Pivot Table 0
VB Solution for a INDEX Array Problem 1
creating a report for an access pivot table 3
Creating a pivot table in Access 2003 0
PIVOT - Reference a cell outside the table for report filtering 2
Enable the page area only of a pivot table for protected worksheet 0
Access 2003: Is it possible to create a "Report" of Pivot Table? 0

Top