Excel's Pivot Tables

[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?

 

[Glen Bunnell]

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.