I am trying to run a pivot table report from an access database and I cannot
get the pivot table to sum. It will show a count, but not a sum. When I
choose the sum function, I get zero. I have used pt but this is the first
time that I have had a problem and I am wondering if it has something to do
with the way the database was set up in access.