Pivot table Problem

R

ravindar thati

Hello friends,

I am using ms access 2003, and Vb6.
i am displaying a table in a form as pivot table (following "Auto
Form: Pivot Table" Wizard)

Usually i select the items i want to be displayed in the pivot table
by dragging them on to the pivot Table from Pivot Fields.
But i got a Problem.
My table wil have Columns Dynamically.
i mean the colums may increase and decrease from time to time.
so my requirement is to display the Updated Table.
I mean the colums which were added must also to be appear on the pivot
table when i Open the form.
is it possible to do so?

Thanq
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dealing with a Pivot Table (when I don't want to) 0
Excel does not accept text format! 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Embed OLE Excel Pivot Tables in Access Forms? Access v2003 and ff. 0
Pivot table report invalid 0
Dynamic Pivot Table 0
auto refreshing data in pivot table 0
Excel 2013 Pivot Data Range formula reference problem 0

Top