i setup a pivot table form and none of my data is in it. i setup a sum of all my fields and everything comes up 0. when you double click on a cell it displays the records that are suppose to be in it. what am i doing wrong? i have been making pivot table in excel for years. this is the first time i have put one into access.