Add additional field to Pivot table

[Kobayashi]

I have created a PT with the wizard, based on a query in my db, but now have modified the query and wish to include an additional field from the query into the Pivot table. However, Pivot tables seem to turn into a different beast altogether when created in Access and I'm completely stuck and just can't seem to be able to add the additional field as it is not showing in the list of fields within the wizard???

I would just re-create the pivot again, using the wizard, but I have since created calls to modules etc and don't want to have to re-create all of the event procedures.

Would really appreciate any help!

Thanks,

Adrian