Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Pivot Table Add Field In Datasource

Status
Not open for further replies.

kennedymr2

Programmer
May 23, 2001
594
AU
I did post this question in [forms] quite a while ago and received no replies.. i thought maybe this section may be more suitable .
---------------------------------------------------------

I have been interested in solving this problem for a long time.

I create a pivot table with a query as the datasource.

Later i add an extra field to the table and query.

When i reload the pivot table and look at the fields available to use in the pivot table.. only the original fields are there.. the extra field i added to the datasource, is missing.

>>>???? How do i get the extra field to appear, without recreating the whole thing..

Probably simple ?? but i cannot work it out

Appreciate any help offered.

Kennedymr2

 
All ok... the problem seems to have gone away... It was only happening with Pivot's i created a while ago.

Regards Kennedymr2
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top