I exported a pivottable designed in Access 2003 to Excel and I noticed when checking the data in Excel that the values calculated for standard deviation changed! This only seems to have happened in one column and I can't find a reason for it.
Thanks for your help!
I have the same problem
I'd really like to know what to do. I have three column where the data changes from "SUM" to "COUNT" and I can't see the reason for it or the solution. One reason might be that these three columns were added after the table was made and used and calculated fields were added. thanks for your help! For both of us, because I think my problem is the same as Camille's.
8th Dec 2009