Dynamically add date to column area of pivot table - access 2007

[Closed]
Report
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012
-
Hello,

i created a pivot table in access 2007 the structure looks like this

vessel zone total 1-mar-12 5-mar-12 12-mar-12 25-sep-12
boat1 north 5 2 3


when user updates the table with a new date say 1-Oct-12, i need to automatically add this to the pivot table column area.

any help would be highly appreciated.


2 replies

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
44
Hi smd_excel,

If your question is about Microsoft Access 2007, then the pivot tables in Microsoft Access 2007 are updated dynamically and you don't need to do anything, all you need to do is add an extra record/row of data in the original table and it will be updated automatically in the corresponding Pivot Table.
However, if you have created the table in Microsoft Excel 2007 then you can check the below mentioned steps:

1. Click the PivotTable report.
2. Click the Options tab, in the Data group, click Change Data Source, and then click Change Data Source.
3. In Select a table or range, include the rows till the end of the sheet or till the point you wish to add more data rows.
4. Click OK.
5. Add more data to the original sheet and refresh the pivot report.

Please revert for clarification.

Posts
27
Registration date
Saturday April 18, 2009
Status
Member
Last seen
November 22, 2012

thanks a ton...worked great.

i'm working on another access project and need help in code...and i need to complete in a weeks time...any help wud be appreciated...i posted the 1st query on the forum...pls help