Pivot Table

[goslincm]

I'm trying to put together my first pivot table. I have a tbl_population that contains the following fields:

72005 (contains the 2005 population)
72004
72003
72002
72001
72000
CountyCd (2 digit codes)
UnitType (township, city, etc)
ConsolID PK

I don't know how to do this so I can evaluate the population growth among these years. Appreciate any help with this.

 

[fneily]

I guess you just want to compare the years population to each other since there's no summary.
Using Access 2000, go to the forms object and click New then PivotTable Wizard. On the first step of the Wizard, select your table. Bring over all fields except ConsolID. Click Next and click on the Layout button. Drag CountyCD to Column, drag UnitType to Rows and Drag all the years to the middle, 72005, 72004, etc. Click Ok. Then click the Options button at the bottom of the third step. Deselect the Grand Totals for Rows. Click Ok. Click Finish. You'll get a comparison of CountyCD by UnitType Showing Population.