Pivot Table view of Union Query

[hongluen via AccessMonster.com]

Dear All,

I can see what I need at the Pivot Table view of a Union Query.
However, this cannot be correctly exported to Excel.

Although there is a function of "Export to Microsoft Excel",
however, all "detail data" in Access was gone - leaving only the count of the
data in Excel.
How can I show all these detail data in the data area of the Pivot Table?

Alternatively, is it possible to copy the Pivot Table in Access
and then paste in Excel? I cannot see any Select Rows commands in the pull
down menu.

Thank you very much.

Hong

 

[Guest]

Have you tried creating a select query based on your cross-tab and then
exporting?