MichaelSchulz
Board Regular
- Joined
- Apr 10, 2014
- Messages
- 64
I used Access to create a Pivot Table from the returned record set of a query.
The Pivot Table displays exactly what I want: it shows in the Detail Data field each and every data point at the intersection of the Row area and the Column area without any sort of summarizing. I know that the point of a Pivot Table is to aggregate the data in some way but in this case it just so happens that I need to see the detail just as Access shows it.
The problem is when attempting to export the table to Excel: the Detail Data field empties and, it seems, Excel cannot produce what Access so easily created. This seems to be because Excel is required to perform some sort of calculation to aggregate the data in some fashion.
My thinking is: if Access can so readily create exactly what I need, there ought to be a way to export that table.
How can this be accomplished?
The Pivot Table displays exactly what I want: it shows in the Detail Data field each and every data point at the intersection of the Row area and the Column area without any sort of summarizing. I know that the point of a Pivot Table is to aggregate the data in some way but in this case it just so happens that I need to see the detail just as Access shows it.
The problem is when attempting to export the table to Excel: the Detail Data field empties and, it seems, Excel cannot produce what Access so easily created. This seems to be because Excel is required to perform some sort of calculation to aggregate the data in some fashion.
My thinking is: if Access can so readily create exactly what I need, there ought to be a way to export that table.
How can this be accomplished?
