Field in Pivot Table Field List Not Shown

[Gazzer]

Hi

I am using Access 2002 SP1 and have created a pivot table based on a query which works fine. However if I change the structure of the underlying query by adding another field, the field is not availabe in the Field List in the pivot table. I have used the refresh option but I understand it only applies to the data.

Any ideas?

 

[reddsharkk]

I have exactly the same situation. When in Pivot table almost all the icons are inactive and will not allow me to alter anything. Pleeeaase helpp!!