Excel's Pivot Tables

  • Thread starter Thread starter Melvin Miller
  • Start date Start date
M

Melvin Miller

When I use VBA to create a pivot table from an external MS
Access database, it defaults to counting the data instead
of summing the data. When I use the field settings option
to change "Count of Amount" to "Sum of Amount" everything
goes to zero. I suspect this is because the data it
retrieved from the database is no longer available. How
can I ensure that the pivot table Sums?
 
I've had the same problem when exporting data from an
Access database into Excel. What I had do was multiply
all of the values by 1 in Excel, which then somehow
triggered that these fields are numeric and not text.
 
Back
Top